Repeating sequence

I am trying to write a column that repeats numbers for example
a1 1
a2,1
a3,1
a4,2
a5,2
a6,2
a7,3
a8,3
a9,3

and so on i have 176000 entries so i just cant copy and paste

So, you want three cells which contain 1, and then 3 cells that contain 2, and then 3 cells which contain 3, and so on?

You can put this in cell A4:

=A1+1

after you have filled A1 to A3 with 1, and then copy that formula down as far as you need to.

Hope this helps.

Pete

Thanks Pete, how do i get it to repeat after a couple of cells eg
a1, 1
a2, 1
a3, 1
a4, 2
a5, 2
a5, 2
a6, 1
a7, 1
a8, 1
a10,2
a11,2
a12,2

and so on

Fill cells A1:A3 with the number 1 as before, then fill cells A4:A6 with the number 2, then you can use this formula in A7 (note that you showed A5 twice in your example):

=A1

then copy down.

Hope this helps.

Pete

Thanks, how do i get it to repeat after a couple of cells eg
a1, 1
a2, 1
a3, 1
a4, 2
a5, 2
a5, 2
a6, 1
a7, 1
a8, 1
a10,2
a11,2
a12,2

and so on

Isn't that exactly the same as Post #4?

Pete

I want the numbers to start again after 3 not for them to keep counting