Can any of you kind and clever souls out there in tFB land help me with this please ?
I want to create a table in Excel (2008 version) to hold all the permutations for 24 variables.
Any advice on how to do that would be appreciated.
If anyone knows how to automatically populate it, that would be fantastic.
Or even how to ease the burden of doing it manually.
I can't even remember how to calculate how many permutations that is, so a reminder of that would be helpful too.
The idea is to use the table as a source for lookups, either specific or randomised ones.
That may not be the best solution if I can create a fairly simple formula in Excel to do this on an "on demand" basis, so again if anyone has an idea how to do that, or how to approach it that would be great.
And one other Excel thing, how do you switch off the cell borders for screen display, so that all you see is a blank white space with just the numbers and text showing ?
I really don't know how to drive Microsoft software very well, just as well I don't need a license and MOT.
Comments
Any time
Not if you're A.M.E.R.I.C.A.N.
Ringleader of the Cambridge cartel, pedal champ and king of the dirt boxes (down to 21)
That's an understatement
6.20448402e23 combinations...
I'm not locked in here with you, you are locked in here with me.
X_X
As a general approach what you want to do is implement a fisher-Yates (knuth) shuffle. Google will get you loads of help on this.
If you need each time you do it to be unique then you probably need to keep a list of previously used permutations.