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