Separating Duplicates??

[Wainsworld]

Hi,

First post

I have a list of email addresses for a mailing list that contains
number of duplicate emails. I already know how to highlight th
duplicates through conditional formatting and reorder so all highlighte
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 emai
so that a unique value is left.

Look forward to your reply,

Thanks An

 

[Ron Rosenfeld]

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

 

[Spencer101]

Hi,

First post

I have a list of email addresses for a mailing list that contains
number of duplicate emails. I already know how to highlight th
duplicates through conditional formatting and reorder so all highlighte
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 emai
so that a unique value is left.

Look forward to your reply,

Thanks Ant

There see several ways of doing this. Which version of Excel are yo
using