|I have a large data set. In two columns there names; lets say A = buyer(s) name(s), C = seller(s) name(s).|
There may be 1-4 names, first and surname in each cell, seperated by a comman.
I'm looking for a function that can highlight where one name appears in both columns.
In my head I need a function that picks out different words in each cell. Then a match function.
Any help would be great, I'm at a total loss.
Thank you in Advance!!