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.

Visit Chips's site at www.cpearson.com
he has lots on duplicate problems
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Finger Tips" wrote in message
...
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.

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.