符合條件 随机返回类型 (12015)

M2{=INDEX(F:F,SMALL(IF(MMULT(N(A$2:E$8=H2:L2),ROW(1:5)^0)=5,ROW($2:$8)),RANDBETWEEN(1,SUM(N(MMULT(N(A$2:E$8=H2:L2),ROW(1:5)^0)=5)))))



留言