I have a list of 10 numbers.
From this list, I wish to generate all permutations (5-numbers)
Is there a function i can do this in excel?
I have a list of 10 numbers.
From this list, I wish to generate all permutations (5-numbers)
Is there a function i can do this in excel?
perhaps something on these links will help...
https://www.excelforum.com/excel-for...n-formula.html
or
https://www.excelforum.com/excel-for...mbination.html
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are over 30,000 of these numbers.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Takes (me) a lot of code to do that.
Format col A as text, run PermCombo2, and then sort col A when it completes for lexical order.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks