OK....pretty sure I got it this time:

For 2 lists (A1:A100 and B1:B100)
This formula returns the count of unique items from Col_A that are in Col_B

=SUMPRODUCT(CEILING(COUNTIF(A1:A100,B1:B100)*0.000 1,1)/COUNTIF(B1:B100,B1:B100&""))

It is durable against text, numbers, and blanks.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

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.