Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
ok here's the deal - i have a list of companies with contact information.
some companies have multiple contacts and some contacts are duplicated. sounds simple..but - some of the company names are spelled differently or have ',' '.' or some other difference. remove duplicates does not work because they aren't EXACT duplicates...how can i either delete or mark them somehow using a variable column? here's a sample: abc solutions marco polo 123 main abc solutions, inc marco polo 123 main abc solutions inc. mark jon 123 main abc solutions inc mark jon 123 main abc solutions inc mark jon 123 main abc sol. Inc. ted frank 123 main abc sol. Inc ted frank 123 main this list should be 3 rows afterwards...thanks in advance - Tad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
== INSTEAD OF EXACT? | Excel Discussion (Misc queries) | |||
Need to do an EXACT LOOKUP | Excel Worksheet Functions |