Lotto question: list of every combination of 6 number with no sequence repeated

1) You say you want every combination of 6 numbers but you don't say how many numbers you are choosing from.

2) Are you saying it's not acceptable to generate the list in a single column? A single column would probably be the easiest to implement.

Ok sorry thought it was clear.

The range is column A 1-20 ( which would be numbers of my choosing) but using 1-20 as a reference.
I said about the multiple columns incase 1 set of 6 cells/columns would not be enough.

You may not be interested in this as it is VBA based and doesn't exactly follow your layout guidelines, but it does address the basic problem of counting the number of combinations whose sum falls in a specified range.

Choosing 6 from 20 with order not mattering results in 38760 combinations. For testing I chose numbers in the range 2:40. Fully 47% of the combinations met the criterion that the sum falls in the range 110..140

Here is a summary of the workbook I have uploaded:

The ChosenNumbers worksheet lets you specify your 20 numbers in column-A.It also provides a summary count of how many combinations meet the "sum" criterion.

The MacroGenerated worksheet is created, as the name implies, by running the TestCNR macro. It generates all 38760 combinations using numbers 1..20. Once generated it does not need to be changed. Credit Allen Wyatt at excelribbon.tips for the macro. I have used it entirely unchanged.

The NumbersAndSum worksheet uses the MacroGenerated worksheet values as indices into the User chosen numbers in the ChosenNumbers worksheet to create a 38760 row set of combinations this time using your chosen numbers. I then added a "sum" column. The "Count" cell D8 on the ChosenNumbers worksheet uses this sum to display the count of combinations that meet the "sum" criterion. To see the individula combinations that meet the "sum" criterioon you can simply filter on the Sum column to show only those that fall in the range 110 to 140.

I AM UNABLE TO UPLOAD THE WORKBOOK, ZIPPED IT IS 2.# MB WHICH IS WELL WITHIN ADVERTIZED LIMITS. If there is any interest in this based on my description then I will try to find a way.

Here is the workbook associated with post #4. I was unable to find a way around the posting size limit so what I have done instead is have the workbook dynamically resize itself based on how many combinations are to be generated. It is posted so that it is choosing 6 numbers from 8 resulting in just 28 combinations. Change ChosenNumbers!D3 from 8 to 20 and click the "Compute Combinations" button to have the workbook resize itself to your requirement. I won't bother posting the VBA as it is tangential to the requirements of this thread.

Macros of course need to be enabled.

Sorry to take so long to get back, work and life this time of year is hecktic. Awesome replies and ty so much for this I'll give it a try asap. This is fantastic. Thanks all who replied.

Originally Posted by AliGW

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Yep as soon as I can verify it working and nothing else is needed.

This is absolutely amazing, currently it is amck on the mark of what I needed.
Thanks again.

Glad to help and thanks for the reputation point!