It does work for a table. If whole column is formated than Excel makes no diference between 0 and blank cell -> this doesnt work, blank cells are marked as same as 0. Any idea how to simply aply this for whole column? Thx
Hi, if you select $B:$B, it will work for a column. Please share what formula are you using and the problem you are facing. I will surely help. Thanks.
Thank you!
perfect. thanks
Welcome. I’m glad you found it useful.
I was losing it, thanks for the explanation... It was exactly the error I was running into.
You're welcome!
Simple and short. Thank you.
Thanks
super useful. thanks!
Thanks for appreciating.
Thanks, I was really struggling to find a way to make Excel distinguishing between blank cells and cells with zero values!
Happy to help and thanks for appreciating.
Amazing. Thanks a lot
Awesome. Thanks for sharing...
Absolutely amazing. Thanks very much. Rog
Thanks Rog.
Thank you Sir!
Very useful, thank you 🙂
Thanks a lot for your words.
Much helpful. 😊
Thanks
perfect! thanks
Thanks
It does work for a table. If whole column is formated than Excel makes no diference between 0 and blank cell -> this doesnt work, blank cells are marked as same as 0. Any idea how to simply aply this for whole column? Thx
Hi, if you select $B:$B, it will work for a column. Please share what formula are you using and the problem you are facing. I will surely help. Thanks.
Apparently this does not work for cells with drown down selections
Thank you!
Thanks for your kind response.