Search

I have a list of 15,000 customers. I want to make sure I have no duplications. I can search by name or phone number. Short of sorting by those columns & physically search one by one for duplicates, is there any formula or trick to find duplicate numbers or names in a list?

Have a look at the following link...

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

Hope this helps!