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...
This was so close to solving my issue.
I have it pulling people and it was showing a 0 in the email address column if they didn't have an email address. Your TEXT() solution fixed that. Unfortunately I was also trying to pull in phone numbers.
EDIT: Now I am doing =IF(ISBLANK(FILTER(blahblahblah)),"",FILTER(blahblahblah))
RC2pc the ISBlank worked for me thanks
=IF(ISBLANK(FILTER(A2:M2911,B2:B2911=S4)),"",FILTER(A2:M2911,B2:B2911=S4))
new formula
- Works a charm
