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
|