Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for Empty Cells
I want to filter (using the Advance Filter) for empty cells in the Prod
column. I've tried several critera, like leaving the cell blank, or just entering an apostrophe, but I can't get it to filter for Products where the product code is "blank". How do I specify the criteria in this case? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for Empty Cells
Can you not do it using Autofilter? Blanks and Non-blanks are listed
at the bottom of the range of values in the pull-down. Hope this helps. Pete On Feb 27, 7:05 pm, Kirk P. wrote: I want to filter (using the Advance Filter) for empty cells in the Prod column. I've tried several critera, like leaving the cell blank, or just entering an apostrophe, but I can't get it to filter for Products where the product code is "blank". How do I specify the criteria in this case? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for Empty Cells
One way if the data is text (not numbers) is to use a criteria of:
with the header in x1 and this in X2 ="<?*" Or if you have numbers (with or without text): Say B1:Bxx has your Prod column and B2 is the first row under that header leave the x1 empty and put this in X2 =LEN(B2)=0 Kirk P. wrote: I want to filter (using the Advance Filter) for empty cells in the Prod column. I've tried several critera, like leaving the cell blank, or just entering an apostrophe, but I can't get it to filter for Products where the product code is "blank". How do I specify the criteria in this case? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for Empty Cells
In addition to Dave's examples, you can use the heading from the column
in the main table, and the criteria: ="=" Kirk P. wrote: I want to filter (using the Advance Filter) for empty cells in the Prod column. I've tried several critera, like leaving the cell blank, or just entering an apostrophe, but I can't get it to filter for Products where the product code is "blank". How do I specify the criteria in this case? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for Empty Cells
Ouch!
(This may be a repeat of a previous thread!) Debra Dalgleish wrote: In addition to Dave's examples, you can use the heading from the column in the main table, and the criteria: ="=" Kirk P. wrote: I want to filter (using the Advance Filter) for empty cells in the Prod column. I've tried several critera, like leaving the cell blank, or just entering an apostrophe, but I can't get it to filter for Products where the product code is "blank". How do I specify the criteria in this case? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter for Empty Cells
Not that I remember. But that doesn't mean much! <g
Dave Peterson wrote: Ouch! (This may be a repeat of a previous thread!) Debra Dalgleish wrote: In addition to Dave's examples, you can use the heading from the column in the main table, and the criteria: ="=" Kirk P. wrote: I want to filter (using the Advance Filter) for empty cells in the Prod column. I've tried several critera, like leaving the cell blank, or just entering an apostrophe, but I can't get it to filter for Products where the product code is "blank". How do I specify the criteria in this case? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |