title: #Excel - How do I compare two columns of different length and extract the difference in a separate column?
body: <p>I have two columns, column A with 8000 records, column B with 115k records. I want to <strong>compare A with B</strong> (not all records in A exist in B), and <strong>extract the difference in column C</strong> (i.e, I want data from column A which is not there in column B). </p>
  
  <p>I don't want to highlight them or whatever, I just want the difference for some other use. Tried various possibilities but ended up with C displaying all the values in A, without comparing with B. So frustrating! Help me if you can, thanks!</p>