In my spreadsheet the data looks like this:

Column G
[blank]
24
8
12
[blank]
1
23
10
12
[blank]
1
18
23
25
8
[blank]
15
18
11

I am trying to find a way to count the occurrence of the numbers (stored as text) in each grouping - i.e. between the blanks - and return the value on each line within the grouping.
So for example, it would look like this:

Column G,Column H
24,3
8,3
12,3
,0
1,4
23,4
10,4
12,4
,0
1,5
18,5
23,5
25,5
8,5
,0
15,3
18,3
11,3

I have wracked my brain to use nested if statements to try and count between the blanks, to no avail. I believe this would be most easily done with a macro. Any help would be greatly appreciated!

Thanks,
Tannenbaum