View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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