加總後排序 (11702)

E2:E6{=INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$16,B:B,)=ROW($2:$16),MMULT(N(B$2:B$16=TRANSPOSE(B$2:B$16)),$C$2:$C$16)/1%+ROW($2:$16)),ROW(A1)),2))

F2:F6=SUMIF(B:B,E2,C:C)