View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ChristopherTri ChristopherTri is offline
external usenet poster
 
Posts: 49
Default How do I filter for a blank cell, using custom autofilter

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)?