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
|