Repeat a set of numbers based on dependents

[SG10]

Hi - I want a a set of numbers (0 - 25) to keep repeating itself - but I want the number of times it repeats itself and the highest number to be an input that can be changed easily.

For example, I want it to repeat itself 2 times then keep going into infinity (i.e. 0-25, 0-25, 25+.......). Then change the scenario to repeat it self 1 time and go to 30 instead of 25

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B
1	Repeat	3
2	max	5
3	0
4	1
5	2
6	3
7	4
8	5
9	0
10	1
11	2
12	3
13	4
14	5
15	0
16	1
17	2
18	3
19	4
20	5
21
Sheet5

Cell Formulas
Range	Formula
A3:A20	A3	=TOCOL(IF(SEQUENCE(,B1),SEQUENCE(B2+1,,0)),,1)
Dynamic array formulas.

 

[SG10]

Thank you very much! - but this stops it at 25 on the last set. Is there a way for it to go into infinity beyond that last repeat?

 

[Fluff]

Is there a way for it to go into infinity

No, because there are a finite number of rows in Excel.

 

[SG10]

No, because there are a finite number of rows in Excel.

It doesn't have to be infinite - just need the number to continue (it will be at most until 40)

 

[Fluff]

Ok, how about

=VSTACK(TOCOL(IF(SEQUENCE(,B1),SEQUENCE(B2+1,,0)),,1),SEQUENCE(40,,0))

 

[SG10]

Ok, how about

=VSTACK(TOCOL(IF(SEQUENCE(,B1),SEQUENCE(B2+1,,0)),,1),SEQUENCE(40,,0))

This works! - is there a way to do this without an array formula?

 

[Fluff]

What do you mean without an array formula?

 

[SG10]

What do you mean without an array formula?

Sorry, my terminology might be wrong - I mean without having a formula that spills (the sequence formula spills)

 

[Fluff]

Do you mean you want a drag down formula?
If so why?