中国式排名

=SUMPRODUCT((B$2:B$47>B2)*(1/COUNTIF(B$2:B$47,B$2:B$47)))+1