Chip Pearson has tons of ways of working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

Duplicate entries wrote:

How do I search for duplicate entries in an excel list?

--

Dave Peterson