Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto number
In B1 put 1
In B2 enter: =IF(A2=1,1,B1+1) and copy down -- Gary''s Student - gsnu200907 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
auto increase number if number is double or more | Excel Worksheet Functions | |||
Auto Number | Excel Discussion (Misc queries) | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
assign auto number and auto date | Excel Discussion (Misc queries) |