Forum Discussion
Count blank cell per row
I know that your columns are text columns.
True|False represent 1 and 0 and as you can see in my post I'm converting them with INT.
So yes you could count your Blank Cells since A=="" would result in TRUE and this would result in the number 1 by using the INT function summing the 1s would result in your count value :smileyvery-happy:
Please give it first a try...
BR,
Josef
These are text column
If i do columnA=""" i get True or False, i need to count blank cells
Thansk
I know that your columns are text columns.
True|False represent 1 and 0 and as you can see in my post I'm converting them with INT.
So yes you could count your Blank Cells since A=="" would result in TRUE and this would result in the number 1 by using the INT function summing the 1s would result in your count value :smileyvery-happy:
Please give it first a try...
BR,
Josef
- Works Thanks
You are very welcome 😃