title: Compare two excel worksheets and find unique entries for both based only on email address columns
body: <p>I have two excel worksheets with contact info for our affiliates. We offer two different products, rings and pendants, and have a separate sheet for each product that contains the affiliate contact info for companies ordering that product.</p>
  
  <p>My employer's current issue is overlap. Some of our affiliates sell and market both pendants, and rings, and so they are on both lists.</p>
  
  <p>I've been asked to filter the lists and give them a list of contacts who are unique to each list, as in a list of contacts who just appear on the rings affiliate list, and a list of contacts who just appear on the pendant affiliate list. They also asked for a list of contacts that appear on both lists.</p>
  
  <p>Because of being hand typed, not all of the contact info has been entered in a standardized way, for instance some contacts have a middle initial in one list, and not in the other, or North is abbreviated in one but not the other etc. So I'll need to compare the lists based on the email address column.</p>
  
  <p>Any help would be greatly appreciated. </p>
  
  <p>I'm their web developer, and don't do advanced excel work. My last resort is exporting the tables as csv lists, importing them into a MYSQL database, and writing a quick script to separate and export the lists that I need.</p>