auto number
 

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

auto number
 

In B1 put 1
In B2 enter:
=IF(A2=1,1,B1+1) and copy down
--
Gary''s Student - gsnu200907

auto number
 

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" wrote:

In B1 put 1
In B2 enter:
=IF(A2=1,1,B1+1) and copy down
--
Gary''s Student - gsnu200907

auto number
 

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.

--
Gary''s Student - gsnu200907


"Subrahmanyam" wrote:

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" wrote:

In B1 put 1
In B2 enter:
=IF(A2=1,1,B1+1) and copy down
--
Gary''s Student - gsnu200907