title: Advanced Filter criteria does not work for more than one criterion
body: <p>I am trying to filter a column in Excel (2003). The column is populated with "filenames". I want to filter certain types of files using Excel's "Advanced Filters". 
  The filename column (B) exists in sheet1, and the filter list in sheet2 column B.</p>
  
  <pre><code>  sheet1                sheet2
    column B              column B
  1 Heading             1 Heading
  2 file.doc            2 &lt;&gt;*.doc
  3 file.html           3 &lt;&gt;*.pdf
  4 file.pdf            4 &lt;&gt;*.mp3
  5 ...                 5 ...
  </code></pre>
  
  <p>This is what I have <a href="https://stackoverflow.com/questions/3522647/how-to-filter-for-multiple-criteria-in-excel">found</a> after many hours of search on the Internet. The problem is that this works for one entry, but not all. I.e. if I mark the entire column B in sheet1 and use column B1:B2 in sheet2 as the area criteria then Excel filters out all files that end with ".doc". But if I use column B1:B4 in sheet2 then nothing happens.</p>
  
  <p>What I have tried so far:</p>
  
  <ul>
  <li>"&lt;>*.ext"</li>
  <li>="&lt;>*.ext"</li>
  <li>OR(<em>.ext,</em>.ext2)</li>
  <li>OR("<em>.ext","</em>.ext2")</li>
  <li>=OR(...)</li>
  <li>&lt;>(...)</li>
  <li>ISERROR(SEARCH())</li>
  <li>and many many more...  </li>
  </ul>
  
  <p>What am I doing wrong?</p>