班 校 各排名與進退步 (15371)

G3:J22=SUMPRODUCT((IF(MOD(COLUMN(A1),2)=1,$C$3:$C$22,)=IF(MOD(COLUMN(A1),2)=1,$C3,))*(OFFSET($C$3:$C$22,,MAX(INT(COLUMN(B1)/2)))>OFFSET($C3,,MAX(INT(COLUMN(B1)/2)))))+1

分開G3=COUNTIFS(C:C,C3,D:D,">"&D3)+1

分開H3=COUNTIF(D:D,">"&D3)+1

分開I3=COUNTIFS(C:C,C3,E:E,">"&E3)+1

分開J3=COUNTIF(E:E,">"&E3)+1

K3:L22=TEXT(G3-I3,"進步0名;退步0名;同名")