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?

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?

There may be other characters in there. Try David McRitchies' TRIMALL
function on the range http://www.mvps.org/dmcritchie/excel/join.htm£trimall

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"will b" <will wrote in message
...
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?

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