Permutations of Set of Numbers in a Column

[chelseajonesy]

I have searched all over the internet but am having trouble finding the answer to my problem. I would like to write a macro that will list the possible permutations of a column, in the column right next to it. For instance, see columns 1 and 2:

1	1	Permutation1
2	2	Permutation1
3	3	Permutation1
	1	Permutation2
	3	Permutation2
	2	Permutation2
	2	Permutation3
	1	Permutation3
	3	Permutation3
	2	Permutation4
	3	Permutation4
	1	Permutation4
	3	Permutation5
	1	Permutation5
	2	Permutation5
	3	Permutation6
	2	Permutation6
	1	Permutation6

<tbody>
</tbody>

Obviously column 3 is just labeling permutations, I just need a code for columns 1 and 2. Thanks in advance!!

 

[shg]

What's the expected result in column C?

 

[chelseajonesy]

What's the expected result in column C?

No expected result for column c, just a label.

 

[shg]

OK. Why is that the answer?

 

[chelseajonesy]

I think I'm not being clear enough, my apologies. I do not expect an answer or any information in column c. I simply put in in the original post to label my permutations. Column c is useless to me in my spreadsheet, I only put it here to explain what I'm looking for.

I'm looking for a macro that will give the possible permutations from a range of values from a column (e.g "Column A"), into another column (e.g "Column B"), similar to what is listed above.

 

[shg]

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

	B​	C​
2​	Permutations of Combinations​	​
3​	mMin​
4​	3​
5​	mMax​
6​	3​	Space-delimited Input String​
7​	m​	1 2 3
8​	3​	3 2 1
9​	3​	3 1 2
10​	3​	2 3 1
11​	3​	2 1 3
12​	3​	1 3 2
13​	3​	1 2 3

 

[chelseajonesy]

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

	B​	C​
2​	Permutations of Combinations​
3​	mMin​
4​	3​
5​	mMax​
6​	3​	Space-delimited Input String​
7​	m​	1 2 3
8​	3​	3 2 1
9​	3​	3 1 2
10​	3​	2 3 1
11​	3​	2 1 3
12​	3​	1 3 2
13​	3​	1 2 3

<tbody>
</tbody>

I'm sorry this is not what i'm looking for. I would like for the numbers to appear separately listed down (in the column) rather than across (in a row). All answers I have found have been in a row. Which is why I have posted this thread.