Forum Discussion
Filter function returning a "0" (Zero) when the source cell is blank or null
Hello all, I'm hoping that this isn't too obvious but I've noticed this situation several times and have had to work around it. I have a situation where the output of a FILTER function is cr...
There are many ways in Excel that lead to a result, here is a small suggestion.
Try conditional formatting
How about with
= and (a1 <> ""; a1> = 0)?
a1 is of course your field to be checked.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.