I am having difficulty figuring out how to repeat a pattern in excel so I can do a mail merge and number raffle tickets going down a stack rather than across. The pattern that I am trying to repeat would go like this...
1
501
1001
1501
2001
2501
2
502
1002
1502
2002
2502
3
503
1003
1503
2003
2503
I have done this before but for the life of me can not seem to get it to work today. Thanks in advance for any help you can be.
a1:a6
1
501
1001
1501
2001
2501
a7 =a1+1 then fill down a7
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Assuming your have your first 6 values in A1:A6, put this formula in A7:
=A1+1
then copy this down as far as you need to.
Hope this helps.
Pete
Thank you! Works perfectly.
..or a slightly more complicated version starting in row 2 copied down
Formula:
=IF(MOD((ROW()-2)/6,1)=0,INT((ROW()-1)/6+1),E1+500)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
just for fun
=(MOD(ROWS($A$1:A1)-1,6)+1)*500-499+CEILING(ROWS($A$1:A1)/6,1)-1 filled down
Very smart people hang out here.
Assuming your list starts from A20:
A20:
=MOD((ROWS($1:20)-ROWS($1:$20)),6)*500+INT((ROWS($1:20)-ROWS($1:$20))/6)+1
Drag down
Adjust range to adapt your actual file
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks