compare 2columes of name
PCLIVE Thanks,
I prefer the second one Anywhere in the column
=IF(COUNTIF(A:A,B1)=0,FALSE,TRUE). However i do not understand the range.
The A:A looks at the names in column A and compares with what? Also what does
the B1 do. I tried this but didn't get any comparison.
"PCLIVE" wrote:
Do you want a true if the name appears only in the same row....or anywhere
in the column?
Only in same row:
=A1=A2
Anywhere in the column.
=IF(COUNTIF(A:A,B1)=0,FALSE,TRUE)
HTH,
Paul
--
"Yossy" wrote in message
...
Please is there a way I can compare two columns of names and getting a
true
or false response in the third column, the downside is that the names in
each
column are a combination of first, middle and last names that have been
concatenated together (These comparison are in thousands). Help please.
thanks
E.G
column 1 column 2
John M James Doug S Smith
Mike j john kate Johnson
Hans Kible Lilly T Hanson
|