title: Filtering column in excel with two or more criteria using c#
body: <p>I want to filter a column in excel with two or more criteria. The syntax allows up to two criteria. I used array concept that didn't work. Help me on this. Thank you.</p>
  
  <p>The syntax is <a href="https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.autofilter.aspx" rel="nofollow noreferrer">here</a></p>
  
  <p>My code is below</p>
  
  <pre><code>Range.AutoFilter(Feild:1,Criteria1:"USD", Operator: XlAutoFilterOperator.xlOr,Criteria2:"HKD");
  </code></pre>