Look at the two cells in the foluma bar to see exactly what "hidden"
characters are present
--
Gary''s Student - gsnu200744


"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?