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.

macros or code
 

Hi Neal,

See Chip Pearson's Duplicates page at:

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


---
Regards,
Norman



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

macros or code
 

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