(輔助)F2:F8=SUMIFS(E$2:E2,A$2:A2,A2,D$2:D2,D2) (依A:E欄上下次序) H2:H12=INDEX(A:A,MATCH(1,FREQUENCY(ROW(A1),SUMIF(OFFSET(E$2,,,ROW(E$2:E$8)-1),">0")) ...
確定! 回上一頁