create all sequences without interruption of 2,3,4,5,6,7,8,9 numbers from 01 to 25

create all sequences without interruption of 2,3,4,5,6,7,8,9 numbers from 01 to 25

create all sequences without interruption of 2,3,4,5,6,7,8,9 numbers from 01 to 25
https://www.excelforum.com/attachmen...1&d=1698140517

Try this:

In first column A write number for sequence size.
In column C write starting number (01 in this case).
In column D use formula:

=IF(C6="", MAX($B6:C6), IF(MOD(COUNT($B6:C6), $A6)=0, "", C6+1))

If you want limit for number 25 then use:

=IF(MAX($B6:C6)=25,"",IF(C6="",MAX($B6:C6),IF(MOD(COUNT($B6:C6),$A6)=0,"",C6+1)))

Note that HansDouwe and mine solutions are different.

I was referring to your example for number 3: 010203 030405 050607 070809
maybe you actually wanted to get "all sequences" as HansDouwe suggest: 010203 020304 030405 040506

hello, we have a problem! It was my mistake mla explained the sequences example=
In the number 9 there must be 02,03,04,05,06,07,08,09,10
03.....11 04...12 Just like the others, there will be more sequences in each quantity, another example
group 05- 02,03,04,05,06. 03....06
Sorry for not explaining correctly, they are all sequences from each group

in that case this would be for older excel versions:

=IF(MAX($B6:C6)=25,"",IF(C6="",OFFSET(D6,0,-1*$A6),IF(MOD(COUNT($B6:C6),$A6)=0,"",C6+1)))

hello HANS, PERFECT, thank you
hello zbox, thank you