三科85以上名单 (9439)


F2{=INDEX(A:A,SMALL(IF(MMULT(N(B$2:D$21>85),{1;1;1})=3,ROW($2:$21),99),ROW(A1)))&""


另解{=INDEX(A:A,SMALL(IF((B$2:B$21>85)*(C$2:C$21>85)*(D$2:D$21>85),ROW($2:$21),99),ROW(A1)))&""


留言