指定班別 取前名次 (15305)

H2:J2 下拉{=INDEX(A:A,RIGHT(LARGE(IF(T(OFFSET($E$2,(ROW(A1)-1)/$F$2,))=$B$2:$B$21,$C$2:$C$21/1%+ROW($2:$21),99),MOD(ROW(A1)-1,$F$2)+1),2))&""



留言