中国式排名=SUMPRODUCT((B$2:B$47>B2)*(1/COUNTIF(B$2:B$47,B$2:B$47)))+1

- 阅读全文 -