View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tadder Tadder is offline
external usenet poster
 
Posts: 2
Default not exact duplicates...

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