| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find duplicates, sum column then delete duplicates | Excel Programming | |||
| Check for Duplicates then Sum cells of duplicates | Excel Programming | |||
| Separating Rows | Excel Discussion (Misc queries) | |||
| Separating | Excel Programming | |||
| locating and separating out duplicates | Excel Programming | |||
Linear Mode
