premutations list of selected numbers

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.

I've shown how you can do this in the attached file.

Enter your popular numbers in appropriate groupings into the yellow area, and you will get the possible combinations in the area below row 10.

Row 1 is just a count of the number that you have in each grouping (it will work for letters as well).

Hope this helps.

Pete

thank you very much. this will help me allot. hope i can understand the formule know if i want to do it my self :P

thanks

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete