Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering?
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 "Dendy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering?
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering?
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering | Excel Discussion (Misc queries) | |||
need filtering help | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
filtering | Excel Discussion (Misc queries) | |||
filtering | New Users to Excel |