How do I Filter on Blank Cells in Excel? 2

[mlrmlr]

Hello,

How can I do a custom filter on (Blank)cells?

I would like to filter data that is less than 20 (I know how to do this), and equal to blank cells. I cannot get the blank cells.

Help!

 

[fneily]

that is less than 20 (I know how to do this), and equal to blank cells"
First the above is not correct. You must understand "and"'s and "or"'s. Or forget it. If you're WITHIN a column, it would be OR.

If you turn on Autofilter, click on the dropdown for that field and select Custom. Then in the Custom Autofilter dialog, test for blank first, so the top boxes say "equal" and the next is blank. Then check the OR option and do "is less then" and put 20 in the last box.
At least it worked for me.

 

[yogia]

Hi mlrmlr:

You may also use AdvancedFilter with the following as part of the criterion range ...

=OR(Entry="",Entry<20)

where Entry ids the name of the field you are filtering on.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[mlrmlr]

Thank you Fneily,

Your instructions worked great!

I tried all of the options but the "OR".

Thanks again.

 

[mlrmlr]

Hey, good deal yogia. Thanks for the response.