How to expand a pattern of numbers

[Demona26]

Hello all. I feel like there is an easy answer to this, but I'm struggling with it.
I wish to create a column of numbers that look like Image 1

I can get Excel to repeat the pattern, but I need it to *continue* the pattern so the next lines are like Image 2

Any help would be appreciated

 

[Fluff]

How many numbers do you want & will they always repeat 4 times?

 

[Micron]

If you select the four 1's and the four 2's and drag down, you should get four of every number thereafter (for as far as you drag down)?

 

[jtakw]

Hi,

Here's one way, Enter 1 in A2, formula in A3 and dragged down:

Book3.xlsx
	A
1	Week
2	1
3	1
4	1
5	1
6	2
7	2
8	2
9	2
10	3
11	3
12	3
13	3
14	4
15	4
16	4
17	4
18	5
19	5
20	5
21	5
22	6
Sheet942

Cell Formulas
Range	Formula
A3:A22	A3	=IF(COUNTIF(A$2:A2,A2)<=3,A2,A2+1)

 

[Fluff]

Another option put the number of weeks you want into B1 & this will spill down

+Fluff 1.xlsm
	A	B
1	Week	5
2	1
3	1
4	1
5	1
6	2
7	2
8	2
9	2
10	3
11	3
12	3
13	3
14	4
15	4
16	4
17	4
18	5
19	5
20	5
21	5
22
Main

Cell Formulas
Range	Formula
A2:A21	A2	=INT(SEQUENCE(B1*4,,,0.25))
Dynamic array formulas.

 

[Demona26]

@Micron[/USER]: I tried yours first, but Excel did this: (image 3). I currently have the format to General: changing it to Number did the same thing.
@jtakw: Your formula worked!

Thank you everyone for your assistance. I had to go to #52, so this was a huge help.

 

[Micron]

Number, no decimal places! No code required.

 

[jtakw]

Number, no decimal places! No code required.

View attachment 55432

Notice the pattern isn't consistently 4 of the same number (most likely due to floating decimals).

 

[Micron]

Yes, I noticed. The long and short of it is, if you format the column as stated, a simple alt+drag accomplishes the end result.

 

[jtakw]

@jtakw: Your formula worked!

Thank you everyone for your assistance. I had to go to #52, so this was a huge help.

You're welcome, thanks for the feedback.