D2:D16=SUMIF(B$2:B2,B2,C$2:C2)
F2:F6{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(COUNTIF(B:B,B$2:B$16)=COUNTIF(OFFSET(B$2,,,ROW($1:$15)),B$2:B$16),D$2:D$16/1%+ROW($2:$16)),ROW(A1)),2)),"")
G2:G6=IF(F2="","",SUMIF(B:B,F2,C:C))
I2:I6{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(COUNTIF(B:B,B$2:B$16)=COUNTIF(OFFSET(B$2,,,ROW($1:$15)),B$2:B$16),SUMIF(B$2:B$16,B$2:B$16,C$2:C$16)/1%+ROW($2:$16)),ROW(A1)),2)),"")
區域知道 J2:J6=IFERROR(LOOKUP(1,0/(LARGE(SUMIF(B:B,{"A","B","C","D"},C:C),ROW(A1))=SUMIF(B:B,{"A","B","C","D"},C:C)),{"A","B","C","D"}),"")
留言
張貼留言