| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
