title: Compare 2 lists in Excel ?
body: <p>I have 2 columns in a spreadsheet.  One column has around 26 extra rows than the other.  I've been trying various formulas to highlight or somehow indicate which columns are missing from the smaller of the lists...</p>
  
  <p>I tried filling a 3rd colum with this : </p>
  
  <pre><code>=FIND(B1,A1:A1102)
  </code></pre>
  
  <p>which I though returned 1 if b1 was in the list a1:a1102 alas it doesn't seem to be true.</p>
  
  <p>Anybody got any solutions for comparing 2 lists and isolating differences?</p>
  
  <p>Thanks </p>