|
M3=IF($A3="","",IF(SUMPRODUCT((COUNTIF($A3:$E3,$A3:$E3)=1)*1)=5,1,0))
N3=IF($A3="","",IF(SUMPRODUCT((COUNTIF($A3:$E3,$A3:$E3)=1)*1)<>5,1,0))
P3=IF($A3="","",IF(SUMPRODUCT((COUNTIF($A3:$E3,$A3:$E3)>=3)*1)>0,1,0))
Q3=IF($A3="","",IF(SUMPRODUCT((COUNTIF($A3:$E3,$A3:$E3)>=4)*1)>0,1,0))
如果I15的结果是1不是0的话,(否则不会了)
O3=IF($A3="","",IF(OR(AND(SUMPRODUCT(1/COUNTIF($A3:$E3,$A3:$E3))=2,SUMPRODUCT((COUNTIF($A3:$E3,$A3:$E3)>1)*1)=5),AND(SUMPRODUCT(1/COUNTIF($A3:$E3,$A3:$E3))=3,SUMPRODUCT((COUNTIF($A3:$E3,$A3:$E3)>1)*1)=4) ),1,0)) |
|