各班取前名次 最後同分全取 (14359)

G3:L8{=IFERROR(OFFSET($A$1,RIGHT(LARGE(IF(($B$2:$B$21=IF(G$1<>"",G$1,F$1))*($C$2:$C$21>=LARGE(($B$2:$B$21=IF(G$1<>"",G$1,F$1))*$C$2:$C$21,$E$2)),$C$2:$C$21/1%+ROW($1:$20)),ROW(A1)),2),(G$1="")*2),"")