Compare columns, count matches
Well THAT sure didn't work as soon as I put some duplicates in.
***********
Regards,
Ron
XL2002, WinXP
"Ron Coderre" wrote:
Try this:
=SUMPRODUCT(CEILING(COUNTIF(A1:A100,B1:B100)*0.001 ,1))
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"adodson" wrote:
I'm looking to compare two lists (a1:a10 compared to b1:b10, unnamed). Then,
return the count of original matches between the two lists. For example, if
Joe Schmidt shows once in a1:a10 and twice in b1:b10, then count it only once.
Any advice greatly appreciated? Thank in advance.
P.S. = this will be incorporated into an If statement.
|