Advanced Filter for multiple criteria, including blank cells

[Striperon]

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?

 

[Guest]

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=advanced+filter+excel

Dave

 

[Striperon]

Sorry, I did not write my question very well.

I do know how to use Advanced Filter, ...except for blank cells. It is
the blank cell criteria that I am stuck on.

Sorry, my bad.

 

[Guest]

The contextures.com link I gave in my response shows how to filter for blank
rows:

=C2="" would be your criteria if your data is in C, etc.

Dave