View Single Post
 
Old 07-01-2022, 02:11 AM
Paulrwoolley Paulrwoolley is offline Windows 10 Office 2021
Novice
 
Join Date: Jul 2022
Posts: 8
Paulrwoolley is on a distinguished road
Default 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!
Reply With Quote