serge
Well-known Member
- Joined
- Oct 8, 2008
- Messages
- 1,417
- Office Version
- 2007
- Platform
- Windows
I'm looking for a formula that will be able to return a combination set of 5 numbers from it's lexicographic number.
For a game of 5/39 meaning 5 balls are draw from a pool of 39 balls.
This game have a total of 575757 combinations and each combination of 5 numbers are numbered from 1 to 575757 which is the " lexicographic number " meaning the rank of the combination in the whole possible combinations for this game ( I hope I make sense ? )
So the lexico # : 1 would have the 1st combination : 1 2 3 4 5
the lexico # : 2 would have the 2nd combination : 1 2 3 4 6
etc.. up to the last lexico # 575757 would have the last combination : 35 36 37 38 39
My question is, What formula would be able to return the 5 numbers combination from the Lexico number ?
Assuming my lexico is in cell A1 what would be the numbers from C1:G1 ?
Thank you.
Serge.
For a game of 5/39 meaning 5 balls are draw from a pool of 39 balls.
This game have a total of 575757 combinations and each combination of 5 numbers are numbered from 1 to 575757 which is the " lexicographic number " meaning the rank of the combination in the whole possible combinations for this game ( I hope I make sense ? )
So the lexico # : 1 would have the 1st combination : 1 2 3 4 5
the lexico # : 2 would have the 2nd combination : 1 2 3 4 6
etc.. up to the last lexico # 575757 would have the last combination : 35 36 37 38 39
My question is, What formula would be able to return the 5 numbers combination from the Lexico number ?
Assuming my lexico is in cell A1 what would be the numbers from C1:G1 ?
Thank you.
Serge.