returning blank cell in criteria o
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
|