list permutations
I need a macro that will produce a list of permutations of the numbers 1-5.
There should be 120 permutations ex. 1 2 3 4 5 2 1 3 4 5 1 2 4 3 5 etc. |
list permutations
Have a look he
http://www.j-walk.com/ss/excel/tips/tip46.htm You only will need some minor adaptations to that code. RBS "scott" wrote in message ... I need a macro that will produce a list of permutations of the numbers 1-5. There should be 120 permutations ex. 1 2 3 4 5 2 1 3 4 5 1 2 4 3 5 etc. |
All times are GMT +1. The time now is 08:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com