remove records from a list

  • Thread starter Thread starter Darren
  • Start date Start date
D

Darren

i have a large list of records(10000+)in excel 2000 and
have many duplicate records

does anybody know a method of removing only the unique
records from the list leaving the duplicates

many thanks
darren
 
cheers ron

i've tried the advanced filters before i posted.

i'm not trying to copy the unique records to another
location but actually delete them completely from the
original list

cheers
darren
 
Hi

If you filter in place (unique records) and press the delete button you delete the unique records
After that choose Show all
 
Back
Top