title: Excel: Autofilter exceptions with more than two criteria
body: <p>This is a question that sometimes arises (e.g.: see <a href="https://stackoverflow.com/questions/32891223/autofilter-exceptions-with-more-than-two-criteria">here</a> and <a href="https://stackoverflow.com/questions/32611170/is-there-a-way-to-not-a-criteria-array-in-excel-vba">here</a>) and has almost always been given solutions based on some looping (with <code>AutoFilter()</code> itself or arrays)</p>
  
  <p>For some reason Excel developers limited <code>AutoFilter</code> custom array criteria functioning to a maximum of two, so the following would not work:</p>
  
  <pre><code>    filterNotCriteria = Array("&lt;&gt;A","&lt;&gt;B","&lt;&gt;C")
  
      someRange.AutoFilter field:=1, Criteria1:=filterNotCriteria, Operator:=xlFilterValues
  </code></pre>
  
  <p>While I think it'd be really helpful to have this <code>AutoFilter()</code> functionality <em>fully</em> available as it is for its "not custom" counterpart</p>
  
  <p>So, while awaiting for Excel developers to add it (or fix it, since it looks to me more like a bug), I'd start this question as a public survey (not sure if this is the appropriate way) on what could be the best VBA fix, both from the performance and usability point of view </p>
  
  <p>And I'm adding the first answer to start the ball rolling</p>