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

"akphidelt" wrote:

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"

"Dendy" wrote:

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

"akphidelt" wrote:

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


"Dendy" wrote:


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
Intl. Claim Christopher 8/14/08
Intl. Claim Christopher
Kentucky Cheryl 8/14/08
Kentucky Cheryl
Californi . Elizabeth
Correctional Donna
Learning Julie
International Genie 8/14/08
International Genie