Permutations of a list of numbers
Hi
I am not very competent in Excel..
I have a list of numbers: 2 3 5 7 11 13 17 19 23 29 31 37 41
(i.e. the first 13 prime numbers).
I would like Excel to return a list showing all the (8000+) permutations of those numbers. Eg if it was just the numbers 1 2 3, Excel would return:
1 2 3
1 3 2
2 1 3
2 3 1
3 1 2
3 2 1
If a kind reader would be able to just send me a link to a file that has this done already, it would be greatly appreciated as I do not understand 'modules'!!
Many thanks!
|