I have seen the formula =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) in here
我在这里看到公式= IF(SUMPRODUCT(($ A $ 2:$ A2 = A2)*($ B $ 2:$ B2 = B2))> 1,0,1)
I am confused about this equal sign = ... What is it for ?
我对这个等号感到困惑= ...这是为了什么?
2 个解决方案
#1
2
It is used for comparison.
它用于比较。
If the range $A$2:$A2 is equal to A2, then it evaluates to TRUE.
如果$ A $ 2:$ A2的范围等于A2,则其计算结果为TRUE。
It's similar if you type in a cell =2=2, you'll get TRUE as result, except the one in your question is comparing a range with a single cell.
如果你键入一个单元格= 2 = 2,它就会相似,你得到的结果是TRUE,除了问题中的一个是将一个范围与一个单元格进行比较。
#2
0
Anchoring the top row of the range with $A$2 but allowing it to expand by not anching the row in the second cell reference allows to to have one instance where the sumproduct() will return only one value. If the full range was included in all cells, any value that occurred two or more times would have a 0 value returned.
使用$ A $ 2锚定范围的顶行但允许通过不对第二个单元格引用中的行进行anching来扩展它允许有一个实例,其中sumproduct()将仅返回一个值。如果所有单元格中都包含完整范围,则任何出现两次或更多次的值都将返回0值。
#1
2
It is used for comparison.
它用于比较。
If the range $A$2:$A2 is equal to A2, then it evaluates to TRUE.
如果$ A $ 2:$ A2的范围等于A2,则其计算结果为TRUE。
It's similar if you type in a cell =2=2, you'll get TRUE as result, except the one in your question is comparing a range with a single cell.
如果你键入一个单元格= 2 = 2,它就会相似,你得到的结果是TRUE,除了问题中的一个是将一个范围与一个单元格进行比较。
#2
0
Anchoring the top row of the range with $A$2 but allowing it to expand by not anching the row in the second cell reference allows to to have one instance where the sumproduct() will return only one value. If the full range was included in all cells, any value that occurred two or more times would have a 0 value returned.
使用$ A $ 2锚定范围的顶行但允许通过不对第二个单元格引用中的行进行anching来扩展它允许有一个实例,其中sumproduct()将仅返回一个值。如果所有单元格中都包含完整范围,则任何出现两次或更多次的值都将返回0值。