能帮我简化下下面这条公式吗(同样是针对1——11数字组成的五个数的数组的)
能帮我简化下下面这条公式吗(同样是针对1——11数字组成的五个数的数组的)
=IF(OR(product(countif(A2:E2,{2,7,9}))>0,product(countif(A2:E2,{2,6,10}))>0,product(countif(A2:E2,{3,6,9}))>0,product(countif(A2:E2,{3,6,10}))>0,product(countif(A2:E2,{3,5,9}))>0),",",CONCATENATE(A2,",",B2,",",C2,",",D2,",",E2))