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