Thread: Tricky Excel De-Dupe Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Tricky Excel De-Dupe Problem
wrote:
Hi

I have a list of email addresses and wish to filter the duplicates
based on the first few characters only being duplicated....example....

















So, I need to extract a shorter list with only one row for each
"person"

Anyone got any ideas?

Gary

Add a column with the following formula:

=SUBSTITUTE(A1,MID(A1,FIND("@",A1)-12,12),"")

Then filter for unique entries based upon that column.
Reply With QuoteReply With Quote