Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm

Chillipepper wrote:

How do I remove common information that appears in two different files in excel

--

Dave Peterson