How to match two different cells text, if the text is not in the .
Column A has Bob Fred Tom
Column B has Tom Bob Fred
I would like to match and identify someway
Column A has Bobby Fred Tom
Column B has Fred Tom Bob
That is not a match
I use vlookup to get exact matches. How to get matches if word order is
different?
|