Filtering?

D

Dendy

I have a major list with duplicate email addresses. I would like to be
able to put all the duplicates with the remove first and the duplicate
second. I have a very long list and more to do. How can I pull the
duplicates together and be able to delete all at one time.

Thanks Linda


Company Name First Name Email Address Add/Remove Date
Profit Sharing Connie [email protected]
Intl. Claim Christopher [email protected] 8/14/08
Intl. Claim Christopher [email protected]
Kentucky Cheryl [email protected] 8/14/08
Kentucky Cheryl [email protected]
Californi . Elizabeth [email protected]
Correctional Donna [email protected]
Learning Julie [email protected]
International Genie [email protected] 8/14/08
International Genie [email protected]
 
A

akphidelt

Heres a possible work around where you wouldn't need to use programming.

Sort the data by e-mail. In this example we will say the first e-mail starts
at cell C1
In another column type in the formula

=IF(NOT(C2=C1),"No Duplicate")

Then copy and paste this formula all the way down to the bottom of the list
Now highlight this column and press CTRL G

Now click on Special
Click "formulas"
Uncheck "Numbers" and "Text"

Now press ok, then on one of the highlighted values... right click, then
click on delete, and then click on entire row. And you should be good
 
O

Otto Moehrbach

I don't quite know what you want, but if you sort the table by the email
column, all the same email addresses would be together. Would that help?
HTH Otto
 
D

Dendy

Thank you. This is just about where I need to be.

I would also like to be able to tag both of the duplicate emails and be able
to sort them all together.

Linda
 
A

akphidelt

You're going to have to be a little more descriptive. I do not understand
what you mean by "tag both of the duplicate emails"
 
D

Dendy

I have 6000 address and emails . I am trying to remove the duplicates and
bouncing emails from a blast I sent out.
 
Top