title: Exclusion Filtering in Excel Advanced Filter
body: <p>I cannot get the advanced filter system on excel to exclude a set of criteria like I can include. </p>
  
  <p>So this is the data I have in a table.
  <a href="https://i.stack.imgur.com/agK86.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/agK86.png" alt="enter image description here"></a></p>
  
  <p>Now I click Filter, Advanced, and then under criteria I go into a new sheet with the same headers and the formulas ="&lt;>Director", ="&lt;>Vice President", etc</p>
  
  <p>It looks like this</p>
  
  <p><a href="https://i.stack.imgur.com/Ct2Aa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ct2Aa.png" alt="enter image description here"></a></p>
  
  <p>HOWEVER, it doesn't end up excluding the terms I list! When I do the opposite and use it for inclusion filtering it works like a charm. I just cannot get the opposite to work.</p>
  
  <p>I appreciate all the help!</p>