判斷指定前二名分區 顯示標語 (13404)

H7:M7=IF(OR(MMULT(RANK(IF({1,0},H2,H5),H2:H5),{1;10})={12,21}),"達標",IF(OR(SUMPRODUCT(RANK(H3:H4,H2:H5)*{1;10})={12,21}),"失敗","無法判斷"))

另解{=IFERROR(IF(MATCH(SUM(RIGHT(SMALL(RANK(H2:H5,H2:H5)/1%+ROW(1:4),{1,2}))*{1,10}),{14,41,32,23},)<3,"達標","失敗"),"無法判斷")