You can copy the advanced filter unique records to a new worksheet then delete
the original sheet.

OR...........

You can tag the duplicates then delete the tagged ones.

See Chip Pearson's site for tagging.

http://www.cpearson.com/excel/duplic...gingDuplicates


Gord Dibben MS Excel MVP

On Sun, 29 Apr 2007 12:10:00 -0700, Finger Tips
wrote:

I have a table with 9 columns. Each column has different information like
Title address city state phone ...

I need to delete the records in which the phone # is the same. How can I do
this. I have tried the advanced filter but am not sure if I am doing it
correct. I can get a list of the unique number copied, but what I really
need is for it to delete the whole record or row for leaving just one record
per phone number.