Increment and step

[robdun]

Hi Everyone, New to this but here goes.

I'm trying to find the quickest way to create a single column of numbers which start at 1 and end at 20,000.

I need to increment by 1 every 4th record as follows:-

1
5
9
13
2
6
10
14
3
7
11
15

through to 20,000

I have tried copy and pasting simple formulas such as =(cell above)+1 or +4 but after about 20 records the numbers start repeating, also tried filling series, growth and linear trends, to 20,000 rows, but that doesn't work.

Anyone got any ideas?

Regards

Rob

 

[Gerald Higgins]

Hi, welcome to the board.

The numbers WILL start repeating after a while, unless you have some kind of rule to indicate what to do instead of repeating.

Let's just extend your sample data a little....

1
5
9
13
2
6
10
14
3
7
11
15
4
8
12
16

What comes next ?

 

[robdun]

Hi

Your question has helped me see that after 16 records, the data has to shift again. the next numbers are as follows:



1
5
9
13
2
6
10
14
3
7
11
15
4
8
12
16

17
21
25
29
18
22
26
30
19
23
27
31
20
24
28
32

 

[Gerald Higgins]

The quickest way to do this is probably to just plug the first 16 numbers into the cells, for example into the range A1:A16.

Then in A17...

=A1+16

and copy down as far as required.