班级名次公式: =SUMPRODUCT(($O$2:$O$1528=O2)*(C2<$C$2:$C$1528))+1说明:O列为班级列,C列为总分列,1528是总人数(最大行数)年级名次公式:=RANK(C2,$C$2:$C$1528)说明:C列为总分列,1528为总人数