One way is with a criteria of:

="<?*"

And that cell with the formula isn't really empty. It may look empty, but it
contains a formula.



Joop wrote:

Currently I am struckling with advanced filtering. In my criteria range
one cell contains an IF formula and the false condition it returns an
empty cell "". Problem is now that advanced filter does not treat this
as a true blank cell; it now only matches with strings. So if I have
figure in this column of my database, it is not selected. I would like
to return a true blank from my IF formula, so that everything is
matched both strings and figures. Is this possible?

Bye
Joop

--

Dave Peterson