title: Excel 2007 - Compare 2 columns, find matching values
body: <p>I have two colums. Column A and Column B which have email addresses. Column A has about 3000 rows, Column B has about 1800.  Is there anyway to compare the two columns, and find any fields that match...</p>
  
  <p>And if so, how to either highlight or flag them as a match... or shit, for even simplicitys sake, just give me a count of how many matches were found...</p>
  
  <p>Should i try a macro?  Or is there a forumula that will help with this?</p>