View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ronlaforce ronlaforce is offline
external usenet poster
 
Posts: 2
Default Advanced Filter for blank fields in multiple rows

I need to filter for blank cells. It will usually be a single criteria in
more than one column. It will be 'and'.

I know that I have to place all criteria in the same row for 'and'.
However, I can't seem to filter out the blank cells. I keep getting nothing
or everything. What is the correct method for filtering for blank cells?

Thx,

Ron