I bet that there's a difference between the two strings.

I'd clean up the data in the table and the data that you're matching on.


will b wrote:

If I am using COUNTIF to compare 2 sets of data (e.g. 2 lists of names) that
I have copied from 2 different websites, COUNTIF does not recognize some
names that match. I use TRIM and match the formats and of the 2 data sets,
still does not work 100%. Of Course, when I copy the cell from one set (e.g.
John Doe) and paste it over the the "John Doe" in the other set, it works.
Is there anything else I can do?

--

Dave Peterson