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?

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?

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

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

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

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