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