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.