View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bee Jay Are Es Ay Bee Jay Are Es Ay is offline
external usenet poster
 
Posts: 2
Default How do I filter for a blank cell, using custom autofilter

Thanks
It's so simple, should've figure this out myself.
Regards

"ChristopherTri" wrote:

Turn autofilter on and select "Custom" from the filter drop-down menu.

If you want blanks included in the filter, select "equals" as the criteria
and leave the condition box to the right empty.

Click on "OR" then enter your remaining criteria.

Regards...


"Bee Jay Are Es Ay" wrote:

I want to use AutoFilter, Custom to filter all Data in a field that might
contain Blanks or Specific Criteria, is there a way other than just filtering
(Blanks) or (Non Blanks)?