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

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!

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

"Megan" <[email protected]> wrote in message
news:[email protected]...
> 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!