Repeat pattern every nth cell

[falyas]

Hi Guys,

I want create a formula that will produce the following pattern automatically:

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

Appreciate your help

 

[Snakehips]

falyas,

Welcome.

Try in A1 ..... =CHOOSE(MOD(ROW(A1),8)+1,4,1,1,2,2,3,3,4) and copy down.Hope that helps

 

[AlKey]

Another way

=INDEX({1,1,2,2,3,3,4,4,1},MOD((ROWS(A$1:A1)-1),8)+1)

 

[sheetspread]

Excel 2010
	A
1	1
2	1
3	2
4	2
5	3
6	3
7	4
8	4
9	1
10	1
11	2
12	2
13	3
14	3
15	4
16	4
17	1
18	1
19	2
20	2
21	3
Sheet13

Cell Formulas
Range	Formula
A1	=MOD(INT(ROW(A2)/2)-1,4)+1

works too