中 西式排名 比較 (10035)

C2=SUMPRODUCT((B$2:B$14>=B2)/COUNTIF(B$2:B$14,B$2:B$14))

另解 C2{=COUNT(0/(B2<=(MATCH(B$2:B$14,B$2:B$14,)=ROW($1:$13))*B$2:B$14))

D2=RANK(B2,B:B)