Advanced Filter for Empty Cells

[Guest]

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?

 

[Pete_UK]

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

 

[Dave Peterson]

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

 

[Debra Dalgleish]

In addition to Dave's examples, you can use the heading from the column
in the main table, and the criteria: ="="

 

[Dave Peterson]

Ouch!

(This may be a repeat of a previous thread!)

 

[Debra Dalgleish]

Not that I remember. But that doesn't mean much! <g>