I am trying to find a way to list out all the permutations of 1 2 3 4 & 5 in 5 digit sequences. I know there are 120 permutations, but how do I list them all out in Excel?
I am trying to find a way to list out all the permutations of 1 2 3 4 & 5 in 5 digit sequences. I know there are 120 permutations, but how do I list them all out in Excel?
This site will do that for you:
http://www.ne.jp/asahi/math.edu/ami/myprog/jk_eng.htm
Download the file (it's safe) and then use it. You can look at the macros in it if you wish.
Hope this helps.
Pete
nice one Pete_UK
Denis
Please always attach the sample workbook without sensitive information when asking for help
To add a module
Press Alt + F11 (this is the Visual Basic Environment)
Insert Menu, select Module
Past code there
Close Visual Basic Environment (X)
Thanks Pete_UK, that's great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks