| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Perhaps copy the names to a helper column, then select the column and replace (remove) all dots 'Corporation' 'corp' 'Incorporated' 'Inc' and other un-required words from the front sheet and then again with hte VLookUp area This should provide a better match -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=385398 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a macro to find duplicate names | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
| How do I compare two lists of names in excel? | Excel Discussion (Misc queries) | |||
| Finding duplicate records in Excel | Excel Discussion (Misc queries) | |||
| How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
Threaded Mode
