Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I delete both sets of duplicate data?
Rather than using Advanced Filter in order to filter a data set for unique
values, I want to delete all duplicate data. For example, I have a spreadsheet of email addresses. I have another list of those addresses from the original, master list that no longer work. I have merged the two lists so that those non-working e-mail addresses now show as duplicates. How can I remove those addresses from the master list? |
#2
|
|||
|
|||
One way is to use a helper column that counts occurances.
Say your data is in column A Insert a new column B and put this formula in B1: =countif(a:a,a1)1 and drag down. Add headers to your data (new row 1) and then select column B and do data|filter|autofilter show the rows that have True in them. Delete those visible rows delete the helper column. Chip Pearson has lots of ways to work with duplicates/uniques at: http://www.cpearson.com/excel/duplicat.htm Superpreciosa wrote: Rather than using Advanced Filter in order to filter a data set for unique values, I want to delete all duplicate data. For example, I have a spreadsheet of email addresses. I have another list of those addresses from the original, master list that no longer work. I have merged the two lists so that those non-working e-mail addresses now show as duplicates. How can I remove those addresses from the master list? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Excel graphs - two data sets on the same y-axis? | Excel Discussion (Misc queries) |