D2:D15{=IFERROR(IF(ROW(A1)=1,A2,IF(COUNTIF($A:$A,D1)=COUNTIF(D$1:D1,D1),"TOT:",IF(D1="TOT:",INDEX(A:A,SMALL(IF(MATCH(A$2:A$10,A:A,)=ROW($2:$10),ROW($2:$10)),COUNTIF(D$1:D1,"TOT:")+1)),D1))),"")
E2:E15{=IF(D2="","",IFERROR(INDEX(B:B,SMALL(IF(A$2:A$10=D2,ROW($2:$10)),COUNTIF(D$2:D2,D2))),SUMIF(D$1:D1,D1,E$1:E1)))
留言
張貼留言