On Mon, 13 Jun 2005 06:54:03 -0700, Zip Codes
wrote:

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.

I assume your columns of data have Labels at the top.

You can use the Advanced Filter to do this.

1. Assumption -- your phone numbers are in column B and start in the second
row.

2. In some cell, not in Row 1, enter the formula: =COUNTIF($B$2:B2,B2)=1 Be
sure there is a blank cell above this.
3. Select some cell in your data table.
4. Data/Filter/Advanced Filter
5. Action: Either is OK but for safety's sake would "Copy to another
location.
List Range: Your table should be selected.
Criteria Range: Select the cell entered in step 2 *AND* the blank cell
above it.

<OK


--ron