每班取前幾名 (9463)


E2:E15=IF(ROW(A1)>4*I$2,"",INT((ROW(A1)-1)/I$2)+1)


F2:G15{=IF($E2="","",INDEX(B:B,RIGHT(LARGE(IF($A$2:$A$24=$E2,$C$2:$C$24/1%+ROW($2:$24)),COUNTIF($E$2:$E2,$E2)),2)))


留言