How to compare 2 Excel sheets for 100+ matches?
I have a master list of 3,000 names, and a second sheet that contains 150 names.
I would like to:
1. Highlight in 2nd sheet the names which can be found on the 1st sheet
2. Do a "contains" search rather than exact search on the name to get a hit.
For example, it should ignore spaces, recognize abbreviations (e.g. ltd = limited), or ignore the end of the name (private limited, or whatever I define to be irrelevant).
How do I go about doing this? If there is no ready-made solution, I can at least settle for a direct+exact match first (figured it'd be less complicated than what I need).
Thanks in advance for your help!
|