Forum Discussion
Solved
@COUNTBLANK
The @countblank function is not helping me 😞 Some of the cells are actually merged cells...' For example, some cells are only one cell long, and other cells are merged - spanning 5 cells. ...
- I don't understand why it worked for you.. but here is what I have encountered (an example)
B2 4-May
B3 5/3/2021
B4
B5
B6 4-May
B7
B8 5-May
B9 6-May
B10 7-May
B11
B12
B13 8-May
B14 9-May
B15
B16
B17
B18 10-May
9 "=COUNT(B2:B18)"
I don't understand why it worked for you.. but here is what I have encountered (an example)
B2 4-May
B3 5/3/2021
B4
B5
B6 4-May
B7
B8 5-May
B9 6-May
B10 7-May
B11
B12
B13 8-May
B14 9-May
B15
B16
B17
B18 10-May
9 "=COUNT(B2:B18)"
B2 4-May
B3 5/3/2021
B4
B5
B6 4-May
B7
B8 5-May
B9 6-May
B10 7-May
B11
B12
B13 8-May
B14 9-May
B15
B16
B17
B18 10-May
9 "=COUNT(B2:B18)"
- COUNTBLANK() is my intended use... 😉
- It is not working for me.. I was able to do the RealBlank function from HansVogelaar and it worked as per my needs!!!