排序 總和與出現次數 (13209)

E3{=INDEX(B:B,RIGHT(LARGE((MATCH(B$2:B$17&"",B:B&"",)=ROW($2:$17))*MMULT((B$2:B$17=TRANSPOSE(B$2:B$17))*1,C$2:C$17*1)/1%+ROW($2:$17),ROW(A1)),2))&""

F3=IF(E3="","",SUMIF(B:B,E3,C:C))

H3{=INDEX(B:B,RIGHT(LARGE((MATCH(B$2:B$17&"",B:B&"",)=ROW($2:$17))*COUNTIF(B:B,B$2:B$17)/1%+ROW($2:$17),ROW(A1)),2))&""

I3=IF(H3="","",COUNTIF(B:B,H3))