Difficult is which to delete.

I would use conditional formatting to identify the duplicates and then you
can decide which to delete.

Assume the phone number is in column C, select all the rows in column C and
use conditional formatting with a formula of

=COUNTIF(C:C,C1)1

--
HTH

Bob Phillips

"Zip Codes" wrote in message
...
I have a huge table in excel, about 1500 addresses. The problem is some
of
them are duplicates. The bigger problem is that if they are duplicates
there
is a slight difference in their name. for example 123 designer might be
123
desginer co. but with the same phone number etc. So the phone number is
the
only piece of data that would be the same for a duplicate. Is there a way
to
have excel find all the duplicates in the column with phone numbers then
delete one of the duplicate rows?
i've tried that website with the duplicate tutorials doesn't work.