W2:=IF(AND(N2:P2=Q2:S2,N2:P2=T2:V2),"OK","No")数组公式,Ctrl+Shift+Enter三键结束X2:
=IF((COUNTIF(N2:V2,3)=3)+(COUNTIF(N2:V2,1)=3),IF(COUNTIF(N2:V2,3)=3,3,"")&IF(COUNTIF(N2:V2,1)=3,1,""),"No")效果如图,附件可下载参考
W2:=IF(AND(N2:P2=Q2:S2,N2:P2=T2:V2),"OK","No")数组公式,Ctrl+Shift+Enter三键结束X2:
=IF((COUNTIF(N2:V2,3)=3)+(COUNTIF(N2:V2,1)=3),IF(COUNTIF(N2:V2,3)=3,3,"")&IF(COUNTIF(N2:V2,1)=3,1,""),"No")效果如图,附件可下载参考