Creating groups of 6 numbers from list of 18 numbers

[jag108]

OK, I have a list of numbers, all of which are random. I am trying to create a non-repeating list of numbers in grouips of 6.

I am trying to do this using VBA if possible.

Number list
3
6
10
13
14
16
17
18
23
25
26
27
29
30
31
32
34
38

The ideal output for me would be:
3, 6, 10, 13, 14, 16
17, 18, 23, 25, 26, 27
29, 30, 31, 32, 34, 38
6, 10, 13, 14, 16, 17
18, 23, 25, 26, 27, 29
30, 31, 32, 34, 38, 3
.....
so on and so forth
Loop through until all permutations are exhausted, with out duplicating any groups of 6.
Ultimately I would like all the possible permutations to be unique.

Thanks in advance

 

[Eric W]

And what would you do with this list of 18,564 combinations? I've yet to see a good reason to list them all out. However, if you really want to do it, this topic has been broached many times. Here are a few:

https://www.mrexcel.com/forum/excel-questions/277924-combination-help.html


https://www.mrexcel.com/forum/excel-questions/957595-5-number-combinations-defined-set.html


And supposedly, there's a workbook that will do combinations of n choose m at https://app.box.com/s/b9b9fc06beb63b9562f9 although I haven't tried it out.

 

[jag108]

Hi Eric,

I did not realize there would be that many permutations
I will have a look and see if I can filter out any possible duplicates.

Thanks for taking the time to respond though.

Jag