Autofill Sequence

Q

quincythequill

Can Autofill handle the following sequence? or can anyone suggest a wa
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 an
3751 reaches 500
 
M

Muhammed Rafeek M

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
 
M

Muhammed Rafeek M

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
 
C

CLR

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"
 
L

Leo Heuser

"quincythequill"
<[email protected]> skrev i en
meddelelse
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
Click to expand...


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
 
S

starguy

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.
 
S

starguy

later on if you want to change your function to values then select th
range in which you have (=A?+1) function and copy then right click
paste special > values > Ok
function will be changed to values only
 
S

shail

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
 
Top