Formula to seek and find duplicates
 

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

Formula to seek and find duplicates
 

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

Formula to seek and find duplicates
 

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