RANK(G2,$D$2:$D$11)用D2的数值在 $D$2:$D$11范围内降序排名区域下拉会滑动。姓名语文数学总分排名小明 4130118248RANK(D2,$D2:2:2:D$5)小明 3129117246RANK(D3,$D2:2:2:D$5)小明 2123111234RANK(D4,$D2:2:2:D$5)小明 1122110232RANK(D5,$D2:2:2:D$5)
阅读完成 · 觉得有帮助?