排名與平均 依班 校 (10878)

D2:D16=COUNTIFS($B$2:$B$16,$B2,C$2:C$16,">"&C2)+1

E2:E16=COUNTIF(C:C,">"&C2)+1

D2:E16 複製到 G2:H16 J2:K16

N2:P4{=AVERAGE(IF($B$2:$B$16=$M2,OFFSET($C$2:$C$16,,COLUMN(A1)*3-3)))