How to create a formula for a specific pattern

  • Thread starter Thread starter anita1999
  • Start date Start date
A

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
 
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
 
Back
Top