I have seen the formula =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) in here
I am confused about this equal sign = ... What is it for ?
What does the equals sign in $A$2:$A2=A2 mean?
Viewed 3513
2 Answers
Related
I have seen the formula =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) in here
I am confused about this equal sign = ... What is it for ?