Forum Discussion
TheOldPuterMan
May 10, 2020Brass Contributor
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...
aca247
Feb 21, 2023Copper Contributor
TheOldPuterMan I've had the same issue when just trying to return an array in another sheet i.e. =C2:C330. Simple solution is just put substitute around the whole formula =substitute(formula,"0","").
This works provided you don't want any cells with a 0 value i.e. text only arrays or values <>0.
Hope this helps