| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Comparing two List that a "Close" but not Identical
I have two customer lists. Each lists may contain the same customer but
spelled differently. I am trying to identify the customers that appear on both list. My 2 list look something like this: List1 Banc Two Bear Wagner Bear, Stearns Calyon Financial List2 Bank Two Bear, Wagner Bear Stearns The customers that appear on both lists (using list 1 names) a Banc Two Bear Wagner Bear, Stearns Is it possible to create the list of customers that appear on both list 1 and list 2 ? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: Match one list against another and highlight differenc | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| Comparing and potentially adding two fields | Excel Worksheet Functions | |||
| Creating a list from an existing list. | Excel Worksheet Functions | |||
Linear Mode
