Thread: auto number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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