排序 依票選數 同行相同不計 (9029)

E2:E6=MID("ABCDE",RIGHT(LARGE(MMULT(COLUMN(A:Y)^0,N((B$2:B$26<>C$2:C$26)*FIND(C$2:C$26,"ABCDE")=COLUMN(A:E)))/1%+COLUMN(A:E),ROW(A1)),2),1)

F2:F6=SUMPRODUCT((B$2:B$26<>C$2:C$26)*(C$2:C$26=E2))