Reverse Lexicographix number to Combination

Reply #2

frenchie — Fri, 16 Jul 2010 07:56:57 GMT

Thank you winsumloosesum,

I do appreciate the file ,but what I'm looking for is, a formula that can give me the combination NOT A MACRO, because I want to be able to copy it down.

Thank you.

Reply #1

winsumloosesum — Fri, 16 Jul 2010 02:08:28 GMT

Here you go Frenchie:

http://www.box.net/shared/azz372zfy0

Reverse Lexicographix number to Combination

frenchie — Fri, 16 Jul 2010 00:21:13 GMT

Hi,

I like to know if someone can help please ?

I'm looking to get the 5 numbers combination from de Lexicographic number,for the game 5/56.

I have it the other way around which is, if you want to set it up for you.

In Row1 from D to H put the consecutive number : 1,2,3,4,5.

In Row2 from D to H put the consecutive number : 52,53,54,55,56.

Then in :

Row 5 from D to H, I have my 5 numbers combination draw.

And in : Cell : J5 I have my Lexicographic formula :

=IF($D5= , ,... [ More ]