T
TKT-Tang
Re – Excel CountBlank and IsBlank WorkSheet Functions
For the ease of simulating the query, please proceed as follows :-
1. Enter into cell(A1) a formula, = Row().
2. Fill down from cell(A1) to cell(A23). It shows a series of running
numbers, 1 to 23.
3. Enter into cell(C12) a formula, =COUNTBLANK(A1:A23). The cell
contents show, 0 (that's correct).
4. Erase the cell contents of A11:A13. The cell(C12) shows 3 (that's
correct).
5. Erase the cell contents of A5:A6 ; and then, erase the cell
contents of A20.
6. A new formula is required to evaluate that there are now 2 blocks
of contiguous blank cells (each of which is at least 2-cell high).
7. The blank cell of A20 is not to be counted (because it's merely a
single cell and it's not a contiguous block of at-least-2-high blank
cells, obviously).
8. Please enlighten upon the given results as observed.
9. Regards.
For the ease of simulating the query, please proceed as follows :-
1. Enter into cell(A1) a formula, = Row().
2. Fill down from cell(A1) to cell(A23). It shows a series of running
numbers, 1 to 23.
3. Enter into cell(C12) a formula, =COUNTBLANK(A1:A23). The cell
contents show, 0 (that's correct).
4. Erase the cell contents of A11:A13. The cell(C12) shows 3 (that's
correct).
5. Erase the cell contents of A5:A6 ; and then, erase the cell
contents of A20.
6. A new formula is required to evaluate that there are now 2 blocks
of contiguous blank cells (each of which is at least 2-cell high).
7. The blank cell of A20 is not to be counted (because it's merely a
single cell and it's not a contiguous block of at-least-2-high blank
cells, obviously).
8. Please enlighten upon the given results as observed.
9. Regards.