Counting With Blank Rows
Hi,
If I have a column of numbers like this:
4
5
6 3
7
8
9 3
2
7
4
1 4
How do I count the number of items between the blanks so it will look like I
have it in the example. The number to the right and bottom is the count. So,
for the numbers 4,5 6 the count is three. For 7,8 9 the count is three and for
the numbers 2,7,4,1 the count is four.
Is there a way to do this withoug using a macro?
Thanks.
|