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

B

Bee Jay Are Es Ay

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

ChristopherTri

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top