macros or code

I need some help with creating an excel macro that will take out duplicate
phone numbers in a list . I think I could use the if function but I dont know
how to specifiey the numbers. I have about 1500 entries to sort through and
need a quicker way! Any advice would be greatly appreciated. Thanks Neal.

Hi Neal,

See Chip Pearson's Duplicates page at:

http://www.cpearson.com/excel/duplicat.htm#Replacing


---
Regards,
Norman



"Neal" <Neal@discussions.microsoft.com> wrote in message
news:7D3061B3-8325-49D2-B80C-3EC149B37ED3@microsoft.com...
>I need some help with creating an excel macro that will take out duplicate
> phone numbers in a list . I think I could use the if function but I dont
> know
> how to specifiey the numbers. I have about 1500 entries to sort through
> and
> need a quicker way! Any advice would be greatly appreciated. Thanks Neal.

sort on the phone number column

Assume this is column E

in the next blank column put in a formula like

Assume (F2)

=If(countif($E$2:E2)>1,"Delete","Keep")

then drag fill down the column

Now apply an autofilter to at least this column and filter on Delete

Select all the rows and do Edit=>Delete

Remove the Autofilter and you should have only the unique phone numbers.

Do this on a copy of your data.

--
Regards,
Tom Ogilvy

"Neal" <Neal@discussions.microsoft.com> wrote in message
news:7D3061B3-8325-49D2-B80C-3EC149B37ED3@microsoft.com...
> I need some help with creating an excel macro that will take out duplicate
> phone numbers in a list . I think I could use the if function but I dont
know
> how to specifiey the numbers. I have about 1500 entries to sort through
and
> need a quicker way! Any advice would be greatly appreciated. Thanks Neal.