Count Blanks bw Data

  • Thread starter Thread starter Drew949
  • Start date Start date
D

Drew949

My sheet is layed out like so:

A B
1 Jim 100
2 Dave 200
3 34
4 300
5 43
6 22
7 Steve 44
8 Jim 100
9 Dave 200
10 34
11 300
12 Al 43
13 22
14 Jim 44

I would like a function that would count the number of blank cells
underneath the selected cell until the next filled cell. For example if I
were to use this function on A2, it would return 4. On A9, it would return 2.
Is there any formula that would do this?
Thanks
 
Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"

With the below sample data apply this formula in cell C2..
=MIN(IF(A3:A100<>"",ROW(A3:A100)))-ROW(A3)


Col A Col B Col C
Jim 100 0
Dave 200 4
34 3
300 2
43 1
22 0
Steve 44 0
Jim 100 0
Dave 200 2
34 1
300 0
Al 43 1
22 0
Jim 44

If this post helps click Yes
 
Back
Top