录取名單 (9274)

F2{=IFERROR(OFFSET(B2,,MATCH(1=1,IFERROR(MATCH(-B2,-$N:$N),1)+1<=MATCH(C2:E2,M:M,),)),"")

(有輔助)G3:K12{=INDEX($A:$A,SMALL(IF($F$2:$F$23=G$2,ROW($2:$23),99),ROW(A1)))&""

(無輔助)G3:K12{=INDEX($A:$A,SMALL(IF(RIGHT(SMALL(TEXT((IFERROR(MATCH(-$B$2:$B$23,-$N:$N),1)+1<=MATCH($C$2:$E$23,$M:$M,))*MATCH($C$2:$E$23,$M:$M,),"0;;59")+{10,20,30}+ROW($2:$23)/1%,ROW($1:$22)*3-2))-COLUMN(B1)=0,ROW($2:$23),99),ROW(A1)))&""

無輔助另解{=INDEX($A:$A,SMALL((T(OFFSET($B$1,ROW($1:$22),LEFT(MMULT(($B$2:$B$23>=SUMIF($M:$M,$C$2:$E$23,$N:$N))*{1,2,3},10^{2;1;0}))))<>G$2)/1%+ROW($2:$23),ROW(A1)))&""