View Single Post
  #1   Report Post  
SMDIYDLI
 
Posts: n/a
Default 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.