0

I have a pretty simple question and google can't seem to return what I'm looking for.

Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first column) of these two sheets are email addresses. I would like to merge the two sheets and remove duplicates based on the primary key (email addresses).

Note that I am using Microsoft Excel For Mac 2011

Thank you in advance

plambre
  • 111

1 Answers1

1

What you need to do is copy all content from one sheet and paste it directly below the info in the other sheet so the columns line up. Then select all columns, go to Data > Remove Duplicates.

finc
  • 11