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...
With IF() you return empty strings instead of zeroes, but that won't reduce the spill range. With that the option could be to apply custom number formatting which hides the zeroes.
IMHO, to exclude them at all it's better something like nested filter
=FILTER(FILTER(something),FILTER(something)<>0)
or even better with LET if it's avilable
=LET(myFilter, FILTER(something), Result, FILTER(myFilter, myFilter<>0), Result)
Nested filter works nicely because it reduces the spill range and I use a data validation list. Thanks a lot
NeimadTel , glad to help
