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.