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

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

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

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

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.

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

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

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.