How do I filter for a blank cell, using custom autofilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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...
 
Back
Top