各班取前幾名 並各班排序 (13519)

F2 下拉=IF(ROW(A1)>J$2*3,"",INT((ROW(A1)-1)/J$2)+1&"班")

(有排序) G2:H2 下拉{=IF($F2="","",OFFSET($B$1,RIGHT(LARGE(IF($C$2:$C$27=$F2,$D$2:$D$27/1%+ROW($1:$26)),COUNTIF($F$2:$F2,$F2)),2),(B$1=$C$1)*2))