Hi,

I have a long list 5000+ names i have another list of a similar number i basically want in a third col the name from the second col that is closest the name in the first list.

I did this on an individual basis by splitting list two into individual words (text to col) and then counting the number of words in the specific name in col A. Then the one which matched the closest number of words would be the one that went in the cell.

How can i do this on a mass scale?

I know i can't be 100% right but i'd just like the name thats closest.

Any ideas?

Regards,
Joshua