Extract numbers in Combinations of 6

[howard]

I have a range of numbers in A1:F6

I need a formula or VBA to extract all possible combinations (6 numbers at a time) and place these in A11 onwards containing 6 numbers in each row

See sample data as well as what I am trying to achieve

Dropbox - File Deleted - Simplify your life

www.dropbox.com

I have also posted on

Macro to extract all possible cominations

I have attached a list of numbers I would like VBA code to extract all possible combinations for 6 numbers I have manually extracted 3 combinations to show you what I am trying to achieve It would be appreciated if someone could provide me with code to do this

www.excelforum.com

It would be appreciated if someone could provide me with a solution to the above

 

[jasonb75]

I would suggest making your request a bit clearer to avoid any confusion as to what is required.

In your cross post it was pointed out that there could be around 5 million results with a sample of 16 numbers.

With the sample here containing 16 numbers and the first example result showing a number being duplicated, you are potentially looking at a much higher number of results (possibly as high as 5,000,000,000 results) which would need 5000 sheets of data if you only use columns A:F for the results!

You might get some answers to this, but I don't think that a solution will be possible without a better thought out question.

 

[howard]

Hi Jason

I have 6 numbers in Columns A to C

I would extract combinations in any order from this range into Col E onwards containing 6 numbers in each Col i.e E:E6 , F1:F6 onwards

Dropbox - File Deleted - Simplify your life

www.dropbox.com

 

[jasonb75]

Let's try to simplify this a bit. Assuming that the sample contains all numbers from 1 to 10 (with 1 being in the sample twice).

Should 1,2,3,4,5,6 and 6,5,4,3,2,1 both be shown in the results, or just 1,2,3,4,5,6?

Is 1,1,2,3,4,5 a valid result?

 

[howard]

Thanks for the reply

I only need to see one result for eg 1,2,3,4,5,6.

1,1,2,3,4,5 is a valid result

 

[jasonb75]

Trying to make something work with your data sample is going to be a bit of a tall order. I would suggest that you look at one of the readily avaliable lottery combination generators (google) for a 6 number draw.

If you can find one that will take numbers from a range of cells rather than a pre-defined number set then that will do exactly what you want, but I expect that it will be a case of pairing the lottery numbers drawn with the numbers in your data set to make it work properly.

 

[howard]

Thanks for your input and advise