I really Need help with Formula (Excel 2003)
It means there are no duplicates, you might have invisible characters in one
or the other like trailing/leading spaces. Test the formula on a small
range, put in some values yourself that you are sure are duplicates and you
will see that it works.
--
Regards,
Peo Sjoblom
"Marilyn" wrote in message
...
I get 0 when using this formula. What am I doing wrong
"Teethless mama" wrote:
=SUMPRODUCT(COUNTIF(A1:A9,B1:B9))
"Marilyn" wrote:
I have email addresses in Column A & Column B and I'm trying to find
matching
addresses between both columns. I have tried the following formulas
however,
they are not counting the matching items correctly:
=ISNA(MATCH(B2,$A$2:$A4661,FALSE)) and I have tried this:
=SUMPRODUCT(($A$2:$A$662=A2)--($B$2:$B$662=B2))
What am I doing wrong?
Thanks for the help,
|