using advanced filters with blank/nonblank cells
Posted by richard on February 28, 2001 4:57 PM
Hello all you Excel kings,
I would like to know how to use advanced filters to find blanks or non blanks in a spreadsheet.
I have tired all sorts of things, but nothing has worked.
I can pick up all nonblank numeric cells with >1, but <>>1 does not work.
Is there some general formula to find blank/nonblank cells in a spreadsheet?
Anticipating some reply
Posted by Mark W. on February 28, 2001 5:48 PM
Should be able to use a computed criteria with the ISBLANK() function.
Posted by David Hawley on February 28, 2001 6:04 PM
Hi Richard
For blank cells use: ="="
For non blanks use: ="<>"<p>
Dave
OzGrid Business Applications
