及格與不及格 各科目找出 (14878)

I2:M4{=INDEX($B:$B,SMALL(IF(($C$2:$C$16>=VLOOKUP(T(IF({1},$B$2:$B$16)),$E:$F,2,))*($A$2:$A$16=$H2),ROW($2:$16),99),COLUMN(A1)))&""

I8:M10{=INDEX($B:$B,SMALL(IF(($C$2:$C$16<VLOOKUP(T(IF({1},$B$2:$B$16)),$E:$F,2,))*($A$2:$A$16=$H2),ROW($2:$16),99),COLUMN(A1)))&""



留言