Each column name has respective ID. So I want to see their id which is on the
respective next column to the names. Also I wouldn't know if it is better to
compare without the name concatenate(using each last name, middle and last
name seperately).
Thanks so much for your help

"Mike H" wrote:

From your posted data what would you expect to see for each case in column 3?

Mike

"Yossy" wrote:

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