Excel常用函数素材

英语 78.3 80 82.5 75.6 82.2 70.5 85.2 76.8 85.7

体育 89.6 89.1 80.2 90.1 50.5 85.5 86.5 93.6 49.5

计算机 90.5 76.3 86.3 78.6 91.2 68.6 76.5 81.4 65.8 6 =RANK(A2, $A$1:$A$10,0) 4 =RANK(A2, $A$1:$A$10,0)

4=RANK(A2, $A$1:$A$10,0)