You may want to read some of Chip Pearson's techniques for dealing with
duplicates:
http://www.cpearson.com/excel/duplicat.htm

Julie Melbourne wrote:

How do I deduplicate data in Excel. I have a large database of names and
addresses which I want to check to duplication

--

Dave Peterson