hello im new to excel but i'm using it for a fun project of playing lotto. i found my way to solve hot and cold numbers and everything around that.

but when i have to make combinations it takes ages to finish them. So i wanted to make a list of every possible combination with numbers i selected out of the data i got.

example. i have numbers 5,6,23,12,36,37,40,43,15 i want every premutation but it can only exists out of 6 numbers. and i want it to follow a rule like nr1 has to be <6 nr2 >6<11 nr3 >16<21 ect. is this possible in excel because i dont find a solution and i'm pretty new to the advanced excel thing.