Remove ALL duplicated records, leaving behind NONE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Christopher Dawes said:
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
Click to expand...
Have a look at http://www.cpearson.com/excel/duplicat.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filer for unique records and return all column data for unique rec 1
Find duplicates in address register 2
Address Database Clean-up 3
Removing all duplicate records except one copy 8
Deleting Duplicates, All records unique 7
remove all duplicate records 1
Deleting duplicates Macro question 2
Remove duplicates from list using code 5

Back
Top