Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 -- quincythequill ------------------------------------------------------------------------ quincythequill's Profile: http://www.excelforum.com/member.php...o&userid=37861 View this thread: http://www.excelforum.com/showthread...hreadid=574105 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
Hi
here i am giving you one solution according to my un derstanding: A1 - 1 A2 - =1249+$A$1+A1 now you can drag A2 cell to down you will get result: 1 1251 2501 3751 5001 6251 7501 8751 10001 11251 12501 13751 15001 16251 17501 18751 ......... ......... If yo want 2: A1 - 2 A2 - =1248+$A$1+A1 now you can drag A2 cell to down "quincythequill" wrote: Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 -- quincythequill ------------------------------------------------------------------------ quincythequill's Profile: http://www.excelforum.com/member.php...o&userid=37861 View this thread: http://www.excelforum.com/showthread...hreadid=574105 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
Hi
here i am giving you one solution according to my un derstanding: A1 - 1 A2 - =1250+A1 now you can drag A2 cell to down you will get result: 1 1251 2501 3751 5001 6251 7501 8751 10001 11251 12501 13751 15001 16251 17501 18751 ......... ......... If yo want 2: A1 - 2 A2 - =1250+A1 now you can drag A2 cell to down "quincythequill" wrote: Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 -- quincythequill ------------------------------------------------------------------------ quincythequill's Profile: http://www.excelforum.com/member.php...o&userid=37861 View this thread: http://www.excelforum.com/showthread...hreadid=574105 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
In A1 put 1
In A2 put =A1+1250 In A3 put =A1+2500 In A4 put =A1+3750 Highlight all four cells and drag down......... Vaya con Dios, Chuck, CABGx3 "quincythequill" <quincythequill.2cxri1_1156240806.2141@excelforu m-nospam.com wrote in message news:quincythequill.2cxri1_1156240806.2141@excelfo rum-nospam.com... Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 -- quincythequill ------------------------------------------------------------------------ quincythequill's Profile: http://www.excelforum.com/member.php...o&userid=37861 View this thread: http://www.excelforum.com/showthread...hreadid=574105 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
"quincythequill"
<quincythequill.2cxri1_1156240806.2141@excelforu m-nospam.com skrev i en meddelelse news:quincythequill.2cxri1_1156240806.2141@excelfo rum-nospam.com... Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 quincythequill One way: In e.g. A5 insert this formula: =1250*(MOD(ROW()-ROW($A$5),4))+INT((ROW()-ROW($A$5))/4+1) Copy A5 down as long as necessary. If you start in cell A3, please replace $A$5 by $A$3 -- Best regards Leo Heuser Followup to newsgroup only please. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
enter your first four values in a column say in cell A1 enter 1 in A2 enter 1251 in A3 enter 2501 in A4 enter 3751 now in cell A5 enter =A1+1 and drag it down untill you get your maximum values. hope this would help you. quincythequill Wrote: Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574105 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
later on if you want to change your function to values then select the range in which you have (=A?+1) function and copy then right click paste special values Ok function will be changed to values only. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574105 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofill Sequence
Yes,
Muhammed Rafeek M has given the most simple solution to your query. I myself done that and found it working the way you wanted at A1 type 1 A2 type =1251+A1 now select A1 till A2 and drag down the fill handle. Hope this works for you too. thanks Shail Leo Heuser wrote: "quincythequill" <quincythequill.2cxri1_1156240806.2141@excelforu m-nospam.com skrev i en meddelelse news:quincythequill.2cxri1_1156240806.2141@excelfo rum-nospam.com... Can Autofill handle the following sequence? or can anyone suggest a way to create this sequence in a single column? 1 1251 2501 3751 2 1252 2502 3752 until 1 reaches 1250 and 1251 reaches 2500 and 2501 reaches 3750 and 3751 reaches 5000 quincythequill One way: In e.g. A5 insert this formula: =1250*(MOD(ROW()-ROW($A$5),4))+INT((ROW()-ROW($A$5))/4+1) Copy A5 down as long as necessary. If you start in cell A3, please replace $A$5 by $A$3 -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to autofill strings | Excel Worksheet Functions | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
How do I autofill an alphabetic sequence? (AAA, AAB, etc.) | Excel Discussion (Misc queries) | |||
How to autofill excel with an alphabetic sequence (aaa, aab, etc.. | Excel Discussion (Misc queries) |