auto number

  • Thread starter Thread starter Subrahmanyam
  • Start date Start date
S

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
 
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.
 
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.
 
Back
Top