校排名後 各班排名 (14994)

J2:P21{=OFFSET(A$1,RIGHT(LARGE(MMULT($D$2:$H$21,ROW(1:5)^0)/1%+ROW($1:$20),ROW(A1)),2),$K$1<>K$1)

Q2:Q21=SUM(L2:P2)

R2:R21=COUNTIFS(J:J,J2,Q:Q,">"&Q2)+1