auto number

[Subrahmanyam]

Hi,

Is there any formula to calculate auto numbering in next column based on the
value in the first column of any row.
For example, in the range of a1:a10, if the value is 1 in any row, then in
column B from the same row, it should auto fill numbers from 1 to 10
(increment by 1)

Please help me. This is so important for me.

Thanks in advance

Subbu

 

[Gary''s Student]

In B1 put 1
In B2 enter:
=IF(A2=1,1,B1+1) and copy down

 

[Subrahmanyam]

Hi,

it worked like this.

1
2
3
1 1
2
3
4
5
6
7
8
9

But, i want those first rows in column B above should be Zero untill "1" is
filled in Column A

I hope, i conveyed correctly....please help me.

 

[Gary''s Student]

In B1 enter 0, In B2 enter:
=IF(A2=1,1,IF(B1=0,0,B1+1)) and copy down

Sometimes I need a tiny bit extra information.