J2:J16{=INDEX(B:B,RIGHT(LARGE(C$2:C$16*10^8+ROW($2:$16),ROW(A1)),8))
K2:K16{=IFERROR(INDEX(VLOOKUP(J2,B:H,{3;4;5;6;7},),MATCH(1=1,COUNTIF(K$1:K1,VLOOKUP(J2,B:H,{3;4;5;6;7},))<VLOOKUP(T(IF({1},VLOOKUP(J2,B:H,{3;4;5;6;7},))),M:N,2,),)),"沒錄取")
N2:R7{=INDEX($J:$J,SMALL(IF($K$2:$K$16=$M2,ROW($2:$16),99),COLUMN(A1)))&""
留言
張貼留言