This assumes that your first column of names is column A. Your second
column of names is Column B (assuming). Place the formula in C1 and copy
down. If the value in B1 is found anywhere in column A, then it returns
TRUE, else it returns FALSE. If your data starts in a different other than
row 1, then adjust the formula as necessary.



--

"Yossy" wrote in message
...
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