Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter for multiple criteria, including blank cells
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter for multiple criteria, including blank cells
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter for multiple criteria, including blank cells
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter for multiple criteria, including blank cells
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 -- Brevity is the soul of wit. "Striperon" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using COUNTIF to search for existence | Excel Worksheet Functions | |||
Use Advanced Filter to Detect non blank rows | Excel Discussion (Misc queries) | |||
Advanced Filter (Criteria + Blanks) | Excel Discussion (Misc queries) | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Advanced Filter criteria (formula) | Excel Worksheet Functions |