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...
I'll add another option to the mix which is pretty clean. If you only want text in the "spill" it removes the blank and "0".
=UNIQUE(FILTER(a1:a100,ISTEXT(a1:a100))