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...
sillybilly
Jun 04, 2021Copper Contributor
TheOldPuterMan The simple fix for me was unchecking the 'Show a zero in cells that have zero value'
Located here: File>Options>Advanced>Display options for this worksheet
- Krispo01Oct 26, 2022Copper Contributor
On Mac it can be switched in the Properties (CMD-',') under "View -> Show in Workbook -> Zero Values"
- Leonardo123Apr 19, 2022Copper ContributorThis is the real solution