[SOLVED] Using a Sequence that Restarts N times and SPILLS

I want to Have a Sequence that starts at

10003057 and ends at 10003143

Once the sequence gets to 10003143, I want it to restart back to 10003057.

So I want this to happen N times (it'll change each week so I'll just use a reference a cell). For the sake of this question, we will say N = 3 times

So to be clear, I want it to go from 10003057-10003143 and repeat it 3 times.

What I need help with, is having a formula that will do what I mentioned above and SPILL the result (similar to the Sequence function).

I have a achieved this with an IF formula but this does not SPILL and I am trying to avoid dragging down the formula.

Hi,

another option

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

Try:

Formula:

Please Login or Register  to view this content.

If you have the functions,

Formula:

Please Login or Register  to view this content.

Put the repeat value in A1 and the value to be repeated in A2 (single digits only)

This will work for any number of characters to be repeated:

Formula:

Please Login or Register  to view this content.

You're welcome.



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Originally Posted by dyl019

Thanks Guys the formulas worked. I ended up using the
=LET(a,SEQUENCE(C3-C2+1,,C2),TOCOL(IFERROR(EXPAND(a,,C4),a),,1)).

I have one last question, its pertaining to the same idea.

This time, I need it to repeat the #1 87 times (this too will change, but i'll denote N=87), than the #2 87 times, than the #3 87 Times .... So and so forth.
I'll denote this repetition factor by R=19 (this will also change week to week). I have a formula that does this as well but I want it to SPILL like in the formula you provided!

You guys have a been a great Help.

Hi,

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.