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