Check for duplicates in excel file
 

Is there are formula in excel that will check a file for duplicate entries. I
have a huge list that I know contain duplicate addresses. I seem to recall
that there is such a formula but I can't remember how to do it. I am using
Excel 2003.

Thanks very much for your help.

Dee

See

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


In article ,
Dee wrote:

Is there are formula in excel that will check a file for duplicate entries. I
have a huge list that I know contain duplicate addresses. I seem to recall
that there is such a formula but I can't remember how to do it. I am using
Excel 2003.

Thanks very much for your help.

Dee