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