title: Using NOT in Excel Advanced Filter
body: <p>I am just asking whether it is at all possible using Advanced Filter with NOT and unique records? To explain my logic, this is what I am trying to achieve, I have a column called option codes, in this column there are duplicate values and values that have the word "NULL". Now, what I want to do is to filter on this column all unique values but I also want to keep all rows that have the word NULL in that column, too. I want to do this in one filter rather than having to go back and forth.</p>
  
  <p>Is there away to do this?</p>
  
  <p>Example output would be:</p>
  
  <pre><code>AA
  BB
  CC
  NULL
  NULL
  .
  .
  .
  .
  . 
  </code></pre>