title: How to Compare Each Row in One Column for a Match in Another Column
body: <p>I have values in column B and C. All except 4 from column B should have a matching pair in one of the rows from column C.</p>
  <p>I tried to use the code <code>=FILTER(B:B, ISNA(MATCH(B:B, C:C, 0)))</code> but that only shows me 7 matching values. Any idea why it's not matching the 75 of 79 values?</p>
  <p><a href="https://i.stack.imgur.com/aoUlC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aoUlC.png" alt="enter image description here" /></a></p>