#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Could you possibly upload your file and give some examples of expected results?
|
#3
|
|||
|
|||
|
#4
|
|||
|
|||
I regret, but I have no idea.
|
#5
|
||||
|
||||
I can't help you with a fuzzy search but if there were exact matches then you could apply a Conditional Formatting rule to the first sheet
Code:
=COUNTIF('SEARCH LIST 4 NAMES'!$A$1:$A$7,$A1)
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#6
|
|||
|
|||
I haven't tried it, but you might want to take a look at:
https://www.microsoft.com/en-us/down....aspx?id=15011 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to find exact matches only in an excel spreadsheet | zhead | Excel | 6 | 09-09-2016 07:52 AM |
Compare filenames listed in Excel to external folder. | Chayes | Excel Programming | 3 | 04-02-2016 02:17 PM |
Need to improve speed of Excel macro that searches for whole word matches | Marrick13 | Excel Programming | 20 | 02-19-2016 09:54 AM |
compare, match and count cell contents between sheets | bobsone1 | Excel | 11 | 08-07-2014 10:34 PM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |