ExcelBanter - Separating Duplicates??

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Separating Duplicates?? (https://www.excelbanter.com/excel-discussion-misc-queries/447662-separating-duplicates.html)

Wainsworld

Separating Duplicates??

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

Ron Rosenfeld[_2_]

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

Spencer101

Quote:

Originally Posted by Wainsworld (Post 1607443)

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

All times are GMT +1. The time now is 01:15 PM.