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...
RonaldVallenduuk
Feb 03, 2023Copper Contributor
By far the easiest solution is this:
=FILTER(range&"", condition)
Just add &"" after your range and the zeros are gone. No need for IFs, extra FILTERs or messing with conditional formatting.
Source:
https://stackoverflow.com/questions/64777658/excel-filter-returning-0-for-blank-cells
=FILTER(range&"", condition)
Just add &"" after your range and the zeros are gone. No need for IFs, extra FILTERs or messing with conditional formatting.
Source:
https://stackoverflow.com/questions/64777658/excel-filter-returning-0-for-blank-cells
- HunterofAnswersMay 25, 2023Copper ContributorExcellent, worked like a charm for me and very easy to apply.