Example:
In column D I have a formula like: if(column C >0;hello;"").


But, unfortunately, although the cells seem to be empty actually excell does'nt treat them as empty. Example: if you select the column from first cell to the last one with contains and you do it by pressing ctrl+shift+down arrow, your empty cells will be also selected.
So: do you have a solution in order to treat empty with formulas cells as though they are really empty?

Thank you,
Mihai Vultureanu

Maybe the attached can be of some help

Attached Files

EmptyCells.xlsx (10.2 KB, 16 views)

=COUNTBLANK(D1:D15)
also counts cells with formulae returning "" as empty.

This may not help depending on how you're wanting to act on the information.