View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kirk P. Kirk P. is offline
external usenet poster
 
Posts: 66
Default 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?