How do I merge two spreadsheets so it removes the duplicates?

[Megan]

Is there a way to merge to large spreadsheets together so that it will
automatically remove the duplicates so that only one of the same enteries
remain? Thank you for your help!

 

[JulieD]

Hi Megan

no "automatic" way that i know of, but you might like to have a read of
http://www.cpearson.com/excel/duplicat.htm
Chip's got lots of ideas there on dealing with duplicates.

Cheers
julieD