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

Check out this link of Chip Pearson's:

http://www.cpearson.com/excel/duplic...tingDuplicates

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Oli" wrote in message
...
Need to know how to find name and address duplicates in a rather large
Excel
file.
Are there any ready made formulas etc.....

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
-------------


"Oli" wrote:

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