pls help, is there an easy way to

[jvoortman]

pls help, is there an easy way to fill down a column with numbers in a
certain sequence? I want to go down a column; cell A1 would be 1, A2
would be 5, A3 would be 9, A4 would be 13, A5 would be 2, A6 would be
6, etc., , I want to end up with a column of numbers that I can paste
into a label program. My problem is that the labels are 4 across and
20 up and down, and I want the numbers to go down the column instead
of across, which is what happens when I just put consecutive numbers
in it, but if I could have every 4th number count then it would work
I think

 

[jvoortman]

pls help, is there an easy way to fill down a column with numbers in a
certain sequence? I want to go down a column; cell A1 would be 1, A2
would be 5, A3 would be 9, A4 would be 13, A5 would be 2, A6 would be
6, etc., , I want to end up with a column of numbers that I can paste
into a label program. My problem is that the labels are 4 across and
20 up and down, and I want the numbers to go down the column instead
of across, which is what happens when I just put consecutive numbers
in it, but if I could have every 4th number count then it would work
I think

I tried typing in the first 4 numbers and then in the next 4 cells
below that I siad to add 1 to the corresponding cell abovce, but it
starts to repeat shortly thereafter (see below)\
1
5
9
13
2
6
10
14
3
7
11
15
4
8
12
16
5
9
13
17
6
10
14
18
7
11
15
19

 

[Bernard Liengme]

You want in column A:
1, 5, 9, 13, 2, 6, ETC
How do we know what ETC is?
Do you want to repeat the 1,5,9,13,2,6 ?
best wishes

 

[jvoortman]

oops, I want to count up to 2,000 in that sequence/series

 

[dq]

If I understand you correctly, your sequence shouldn't be 1, 5, 9, 13
but 1, 21, 41, 61 and then add 1 each time. This would make your first
column of labels then 1, 2, 3, 4, etc.

DQ

 

[Bernard Liengme]

So how do we know what comes after 6 ?

 

[jvoortman]

what I tried was to put in cell A5 "=A1+1", and in cell A6 "A2+1", and
in cell A7 "A3+1", and in cell A8 "A4+1, and then I tried to do a
"fill down", but it starts to repeat numbers so that won't work. I
just want a list of numbers 1 through 2,000 and in the order as shown
in the sample. Sorry, if I am not explaining myself properly, and
thereby causing confusion.

 

[jvoortman]

If I understand you correctly, your sequence shouldn't be 1, 5, 9, 13
but 1, 21, 41, 61 and then add 1 each time. This would make your first
column of labels then 1, 2, 3, 4, etc.

DQ

not really, your way would just put the number at the top of each
column, whereas I want the numbers to fill the columns

 

[Bernard Liengme]

Try copying (by pulling the fill handle) just the LAST formula
best wishes

 

[jvoortman]

that doesn't work becasue the numbers while going up as I wished, they
repeat all over the place (see exampel), and it looks to be about 15
cells
1
5
9
13
2
6
10
14
3
7
11
15
4
8
12
16
5
9
13
17
6
10
14
18
7
11
15
19
8
12
16
20
9
13
17
21
10
14
18

 

[jvoortman]

that doesn't work becasue the numbers while going up as I wished, they
repeat all over the place (see exampel), and it looks to be about 15
cells
1
5
9
13
2
6
10
14
3
7
11
15
4
8
12
16
5
9
13
17
6
10
14
18
7
11
15
19
8
12
16
20
9
13
17
21
10
14
18

Thanks anyway everyone......I give up!

 

[David Biddulph]

Hopefully you have learned that you need to ask the right question in order
to get the right answer.

You've specified a series which gives you numbers from 1 to 16 in the order
you specified (going up by 4 for each of the first 3 steps then going down
by 11 for the 4th step, then up by 4 for each of the next 3 steps, and so
on).
Are you trying to say that when you get to 16, you then don't want to follow
the series you specified and go down by 11 (which would give you 5 for the
second time) but perhaps that you want to go up by 1 to 17, and then restart
a series from there for the next 16 numbers?

If so, what about:
=4*(MOD(ROW()-1,4))+INT((ROW()-1)/4)+1+12*INT((ROW()-1)/16) ?

 

[Bob Umlas]

put in the 1 and 5 in A1 and A2, then use the fill handle to create
9,13,17,21,25,... as far down as you want.
Bob Umlas
Excel MVP