title: C# Filter excel columns on more than one value
body: <p>I am exporting a data table to an excel in my windows form based application using C#.  The FilterList has the below values</p>
  
  <pre><code>string[] FilterList = new string[] {"Red", "Blue"};
  </code></pre>
  
  <p>But I only get the values filtered by "Blue". Below is the partial code where I am applying filter on one of my column.The column I am trying to filter has 7 different values in it from which I want to select only 2.</p>
  
  <pre><code>Microsoft.Office.Interop.Excel.Application app = new
  Microsoft.Office.Interop.Excel.Application();   
          app.Visible = false;
  
          Workbook wb = app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);   
          Worksheet ws = (Worksheet)wb.ActiveSheet;
  
         // Some business logic to fill the excel.............
  
          Range firstRow = (Excel.Range)ws.Rows[1];
          firstRow.Activate();
          firstRow.Select();
          firstRow.AutoFilter(5, FilterList.Count &gt; 0 ? FilterList :
          Type.Missing,Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true);
  </code></pre>
  
  <p>What am I doing wrongly here, Any help </p>