選手 選拔 (11457)

G2:I26{=IF(ROW(A1)>$E$2*2,"",INDEX(A:A,RIGHT(LARGE(MMULT(1-ISERR(FIND({"男","女"},$A$2:$A$27)),{1;2})*10^8+$C$2:$C$27*10^6+$B$2:$B$27/1%+ROW($2:$27),ROW(A1)+(ROW(A1)>$E$2)*(15-$E$2)),2)))