Most valuable professional
  • Hot Topics

Excel Combination from Lexicographic number.

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.

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of April 29, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel