|
初学,请前辈帮看下这个公式的错误原因在哪里:=IF(OR(COUNTIF(IF(A1:F1-TRANSPOSE(A3:F3)=-3,COLUMN(A:F))+IF(A1:F1-TRANSPOSE(A5:F5)=-2,COLUMN(A:F)),"1")>1,COUNTIF(IF(A1:F1-TRANSPOSE(A3:F3)=-3,COLUMN(A:F))+IF(A1:F1-TRANSPOSE(A5:F5)=-2,COLUMN(A:F)),"2")>1,COUNTIF(IF(A1:F1-TRANSPOSE(A3:F3)=-3,COLUMN(A:F))+IF(A1:F1-TRANSPOSE(A5:F5)=-2,COLUMN(A:F)),"3")>1,COUNTIF(IF(A1:F1-TRANSPOSE(A3:F3)=-3,COLUMN(A:F))+IF(A1:F1-TRANSPOSE(A5:F5)=-2,COLUMN(A:F)),"4")>1,COUNTIF(IF(A1:F1-TRANSPOSE(A3:F3)=-3,COLUMN(A:F))+IF(A1:F1-TRANSPOSE(A5:F5)=-2,COLUMN(A:F)),"5")>1,COUNTIF(IF(A1:F1-TRANSPOSE(A3:F3)=-3,COLUMN(A:F))+IF(A1:F1-TRANSPOSE(A5:F5)=-2,COLUMN(A:F)),"6")>1),"1",0)
非常感谢有这么好的平台和众多的前辈提供学习资源,先谢过各路前辈
具体内容在附件,帮给出一个合理的计算方式
|
|