How to create a formula for a specific pattern

[anita1999]

I'm trying to do the following but don't know if it is possible. I want
to generate a formula such that when I do a Fill-Down it will
automatically generate the following: Basically, it will group 1,2 and
print it out twice and then it will increment and 3,4 and print it out
twice in the column and then it will increment. Any pointers would be
very much appreciated. Please send email to (e-mail address removed)
Thanks,

1
1
1
1
2
2
2
2
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
3
3
3
3
4
4
4
4
5
5
5
5
6
6
6
6
5
5
5
5
6
6
6
6

 

[Bernie Deitrick]

Anita,

Enter the formula

=(INT((ROW(A1)-1)/16)+1)*2-(MOD(ROW(A1)-1,4)=MOD(ROW(A1)-1,8))

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP