Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove ALL duplicated records, leaving behind NONE
Hello,
I have a distribution mailing list of individual names that I would like to replace with group names that individuals are members of, without resorting to the eyeball method. In this example, Chris & Johnston belong to a Product Group, so I can replace them in my Master List with the Product Group in my Revised Master List. I would like to identify Chris & Johnston as duplicates and remove them entirely, as opposed to relisting Chris & Johnston as unique records. I realize that this is far better suited to Access, but don't have Access. Any way to do this in Excel? Master List Product Group Want This: Not This: Angela Angela Angela Chris Chris Chris Dominique Dominique Dominique Johnston Johnston Johnston Maria Maria Maria Michelle Michelle Michelle I've tried using the Advanced Filter to display unique records, but that relists the unique record, rather than eliminating it from the results. Thanks, Chris |
#3
|
|||
|
|||
Thanks, I already did. It doesn't address the situation outlined.
"bigwheel" wrote: "Christopher Dawes" <Christopher wrote in message ... Hello, I have a distribution mailing list of individual names that I would like to replace with group names that individuals are members of, without resorting to the eyeball method. In this example, Chris & Johnston belong to a Product Group, so I can replace them in my Master List with the Product Group in my Revised Master List. I would like to identify Chris & Johnston as duplicates and remove them entirely, as opposed to relisting Chris & Johnston as unique records. I realize that this is far better suited to Access, but don't have Access. Any way to do this in Excel? Master List Product Group Want This: Not This: Angela Angela Angela Chris Chris Chris Dominique Dominique Dominique Johnston Johnston Johnston Maria Maria Maria Michelle Michelle Michelle I've tried using the Advanced Filter to display unique records, but that relists the unique record, rather than eliminating it from the results. Thanks, Chris Have a look at http://www.cpearson.com/excel/duplicat.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i delete multiple records from my database | Excel Discussion (Misc queries) | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS. | Excel Worksheet Functions |