Merging two excel files

S

SPARKLYSCOTTY

Hi folks. I have two mailling lists that I would like to turn into one.
Is there a way to merge the data where duplicate entries are
automatically found and removed?
Thanks! :confused:
 
D

Debra Dalgleish

Copy both lists onto one worksheet. Then, Chip Pearson has information
on finding and tagging duplicate entries in a list.

http://www.cpearson.com/excel/duplicat.htm

After you've tagged them, use an AutoFilter to filter them, and delete
the visible rows. Or, sort by the Tag column, and delete the duplicates.
 
Top