Merge two files and then allowing deletion of duplicate cells?

C

candygrl7300

My supervisor wants me to figure out how to merge two files (we know how to
do this) but then set it up so that if there are any duplicate cells/cell
rows in the two files, they will automatically delete. Anyone know if this is
even a possible function?
 
G

GoHokiesJLK

I *just* learned how to do this this week... Office Online has this article:

http://office.microsoft.com/en-us/assistance/HA010346261033.aspx

Basically, use the Data -> Filter -> Advanced Filter command.

There is a checkbox for "Unique records only" that you need to check.

The important part in the "Criteria range:" box. I used "column b" for my
worksheet, so that field ends up looking like this: Sheet1!$B:$B

Hope this helps,
jlk
 
Top