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" wrote in message
...
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!