sort but not at random.

[tony0217]

So i have searched for this topic already i promise.
the problem is i have 1 column that goes from a to d.
im trying to develop a way to sort this column in every way and have it post to a new column directly next to it until all possible arrangements have been done.

so im basically rearranging the column and posting it next to the previous one and so on until there are no more possibilities left. using A to E there should be about 5,040 combinations.

How can i accomplish this?
please help thank you.

 

[Eric W]

Try searching for "permutation" or "combination". This topic has been covered many times.

Using the letters A-E, there are 120 combinations. Using the letters A-G, there are 5040 combinations.

 

[tony0217]

theres nothing around explaining how to do this

 

[Eric W]

Here are 4 I found in about 60 seconds of searching:

http://www.mrexcel.com/forum/excel-questions/695593-permutation-macro-help-please.html
Mix And Match – Get all possible permutations of an unlimited number of lists in Excel | Struggling To Excel
http://www.mrexcel.com/forum/excel-questions/885321-all-combinations-multiple-columns-values.html
http://www.mrexcel.com/forum/excel-...ble-combinations-two-lists-without-macro.html


There are formula methods, and macro methods. You should be able to find something useful in there.