remove records from a list

[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

 

[Ron de Bruin]

Use Advanced Filter

See this webpage for a example
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[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

 

[Ron de Bruin]

Hi

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

 

[darren]

many thanks

-----Original Message-----
Hi

If you filter in place (unique records) and press the

delete button you delete the unique records