List of 15 elements, need to generate all 6 element combinations.

**j4c0b5m17h** · 09-22-2013, 01:24 PM

Hey so like the title says, I have a list of 15 elements in column a and I'd like to list all possible 6 element combinations in a18 and beyond (each element being on its own column on the same row. I'm assuming I'll have to use a macro but I don't know how to do that...?

**alansidman** · 09-22-2013, 01:35 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**shg** · 09-22-2013, 02:06 PM

There's a workbook that will do this at https://app.box.com/s/b9b9fc06beb63b9562f9

	A	B
2	n
3	18
4	mMin
5	6
6	mMax
7	6
8	nComb
9	18,564
10
11	m	1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 18 17 18
12	6	6 5 4 3 2 1
13	6	7 5 4 3 2 1
14	6	7 6 4 3 2 1
15	6	7 6 5 3 2 1
16	6	7 6 5 4 2 1
17	6	7 6 5 4 3 1
18	6	7 6 5 4 3 2
19	6	8 5 4 3 2 1
20	6	8 6 4 3 2 1
21	6	8 6 5 3 2 1
22	6	8 6 5 4 2 1
23	6	8 6 5 4 3 1
24	6	8 6 5 4 3 2
25	6	8 7 4 3 2 1
26	6	8 7 5 3 2 1
27	6	8 7 5 4 2 1
28	6	8 7 5 4 3 1

**shg** · 09-22-2013, 02:11 PM

Sorry, the example should be ...

	A	B
2	n
3	15
4	mMin
5	6
6	mMax
7	6
8	nComb
9	5,005
10
11	m	1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
12	6	6 5 4 3 2 1
13	6	7 5 4 3 2 1
14	6	7 6 4 3 2 1
15	6	7 6 5 3 2 1
16	6	7 6 5 4 2 1
17	6	7 6 5 4 3 1
18	6	7 6 5 4 3 2
19	6	8 5 4 3 2 1
20	6	8 6 4 3 2 1
21	6	8 6 5 3 2 1
22	6	8 6 5 4 2 1
23	6	8 6 5 4 3 1
24	6	8 6 5 4 3 2
25	6	8 7 4 3 2 1
26	6	8 7 5 3 2 1