Formula to seek and find duplicates

[Oli]

Need to know how to find name and address duplicates in a rather large Excel
file.
Are there any ready made formulas etc.....

 

[Ragdyer]

Check out this link of Chip Pearson's:

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

You can scroll up and down to find a variety of procedures in dealing with
duplicates.

 

[Anuj]

Excel 2007 has this feature built in..

... If you are using earlier versions I would recommend that you try the
freeware at

http://www.powerutilsnet.com/download.htm

I have found this very useful while I was using earlier versions.

Anuj