S
scott
In one row I have information. What I want to do is if there is information
in that row I want excel to count. Say I have a range with 20 rows. In the
first five rows there is no information but in the 6th row there is
information. I want to assign the number 1 (This can be in a seperate
column.) Then say there are 2 or 3 blank rows and another set of information
comes up in that seperate column I want the number two to show up and so on.
Here is my original formula but all I ever get is 1 and 2 even if multiply
entrees.
=count(offset(A1,0,0,Row(1:1)
This formula is in a seperate column. Going down the column this next
formula would be
=count(offset(A2,0,0,Row(2:2) and so on
If this formula goes down 20 rows I get what I want on the first 2 (Numbered
1 and 2) but by the third entree 4 of 5 rows down I get 1 again.
Thanks Scott
in that row I want excel to count. Say I have a range with 20 rows. In the
first five rows there is no information but in the 6th row there is
information. I want to assign the number 1 (This can be in a seperate
column.) Then say there are 2 or 3 blank rows and another set of information
comes up in that seperate column I want the number two to show up and so on.
Here is my original formula but all I ever get is 1 and 2 even if multiply
entrees.
=count(offset(A1,0,0,Row(1:1)
This formula is in a seperate column. Going down the column this next
formula would be
=count(offset(A2,0,0,Row(2:2) and so on
If this formula goes down 20 rows I get what I want on the first 2 (Numbered
1 and 2) but by the third entree 4 of 5 rows down I get 1 again.
Thanks Scott