取各組前名次人員 (9962)


G2:I21{=IFERROR(INDEX(A:A,RIGHT(LARGE(IF(INT((ROW(A1)-1)/$E$2)+1=$C$2:$C$21,$B$2:$B$21/1%+ROW($2:$21)),MOD(ROW(A1)-1,$E$2)+1),2)),"")


留言