View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
 
Posts: 179
Default 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