[已解决]如何根据数值进行排列

black21

大神们有什么公式可以得到D列那样的排列顺序

最佳答案

月排行榜 / 总排行榜

砂海

2021-4-19 17:58

D2=SUM(C$1:C1)+1&IF(C2=1,"","-"&SUM(C$1:C2))

跳转到最佳答案楼层

砂海

D2=SUM(C$1:C1)+1&IF(C2=1,"","-"&SUM(C$1:C2))