Hi Excel Guru's!
Long Story Short - I need to find similarities between two columns of names which may be formatted slightly differently.
Goal: to find out which company contacts (COLUMN A - see attached) will be at a conference (COLUMN B - see attached).
The attached is obviously just an example illustrating the issue I'm having.
As you can see, I have put some of the same companies in Columns A and B, but the names do not match up exactly. This is the biggest problem.
Could you advise as to what to do or which functions to use to search two (RATHER LARGE) lists quickly to find similarities?
Thanks in advance!!
Bookmarks