View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
Posts: 1,045
Default Separating Duplicates??

On Fri, 16 Nov 2012 10:34:39 +0000, Wainsworld wrote:


Hi,

First post :)

I have a list of email addresses for a mailing list that contains a
number of duplicate emails. I already know how to highlight the
duplicates through conditional formatting and reorder so all highlighted
cells are at the top.

I cannot figure out how to separate duplicates...

So i have an email that appears 3 times, i need to delete 2 of the email
so that a unique value is left.

Look forward to your reply,

Thanks Ant


Excel 2007+ On the Data Ribbon -- Data Tools tab -- Remove duplicates