Welcome Guest
Log In | Register )
You last visited December 5, 2016, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

Reverse Lexicographix number to Combination

Topic closed. 2 replies. Last post 6 years ago by frenchie.

Page 1 of 1
PrintE-mailLink
frenchie's avatar - Lottery-041.jpg
Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
Posted: July 15, 2010, 8:21 pm - IP Logged

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="","",COMBIN($H$2,$H$1)-IF($D$2-$D5>0,COMBIN($H$2-$D5,$H$1),0)-IF($E$2-$E5>0,

COMBIN($H$2-$E5,$G$1),0)-IF($F$2-$F5>0,COMBIN($H$2-$F5,$F$1),0)-IF($G$2-$G5>0,

COMBIN($H$2-$G5,$E$1),0)-IF($H$2-$H5>0,COMBIN($H$2-$H5,$D$1)))


Can someone be able to use the same set up but the other way around ?

By putting the Lexicographic number in : J5 and that will give me the combination ?

                                                                                                                Thank you.        Serge.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: July 15, 2010, 10:08 pm - IP Logged

    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="","",COMBIN($H$2,$H$1)-IF($D$2-$D5>0,COMBIN($H$2-$D5,$H$1),0)-IF($E$2-$E5>0,

    COMBIN($H$2-$E5,$G$1),0)-IF($F$2-$F5>0,COMBIN($H$2-$F5,$F$1),0)-IF($G$2-$G5>0,

    COMBIN($H$2-$G5,$E$1),0)-IF($H$2-$H5>0,COMBIN($H$2-$H5,$D$1)))


    Can someone be able to use the same set up but the other way around ?

    By putting the Lexicographic number in : J5 and that will give me the combination ?

                                                                                                                    Thank you.        Serge.

    Here you go Frenchie:

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

      frenchie's avatar - Lottery-041.jpg
      Los Angeles
      United States
      Member #75410
      June 2, 2009
      479 Posts
      Offline
      Posted: July 16, 2010, 3:56 am - IP Logged

      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.