title: How to compare 2 columns in excel
body: <p>I have Column A and Column B. What I want to do is copy Column C and remove rows which match/contain rows in Column B.</p>
  
  <p>I have this formula but it doesn't remove containing rows, only matching:</p>
  
  <pre><code>=ARRAYFORMULA(IF(ISNA(MATCH(A:A,B:B,0)),A:A,""))
  </code></pre>
  
  <p>Any formula/query for this?</p>
  
  <p>You can see it live here (please comment suggestion there): <a href="https://docs.google.com/spreadsheets/d/1EBJgRAt0UfyfP_zgv3RITNnN3VW3KXoeiIC9mDTjJL4/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1EBJgRAt0UfyfP_zgv3RITNnN3VW3KXoeiIC9mDTjJL4/edit?usp=sharing</a> </p>
  
  <p><a href="https://i.stack.imgur.com/D5taN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D5taN.png" alt="enter image description here"></a></p>