Count Blanks bw Data

[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

 

[Jacob Skaria]

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