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