中式排名 依各班 (10108)

E2=SUMPRODUCT((A$2:A$18=A2)*(C$2:C$18>C2)/COUNTIFS(A$2:A$18,A$2:A$18,C$2:C$18,C$2:C$18))+1

F2=COUNTIFS(A$2:A$18,A2,C$2:C$18,">"&C2)+1