You can test for various conditions in Advanced Filter. See here for an
example: http://www.contextures.com/xladvfilter01.html

Also, see the links provided here for a variety of other examples of
Advanced Filter use:
http://www.google.com/search?hl=en&q...d+filter+excel

Dave
--
Brevity is the soul of wit.


"Striperon" wrote:

I've searched for the answer to this question, but have not found it.
I have a 1435 row and 62 column spreadsheet. I wish to filter for 5
criteria in one column, including blank cells, using Advanced Filter.
How do I do this?