Combination from Lexicographic number.

[serge]

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.

 

[S.H.A.D.O.]

You're welcome,

If you have any queries then please post back.
Enjoy your zzzz's.

 

[serge]

Stephen and SHADO,

I made the change and it work very well now, Thank you so much for the help, I really appreciate it.
Serge.

 

[S.H.A.D.O.]

You're welcome Serge, I am glad you have got it sorted and thanks for the feedback.