Welcome Guest
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
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.

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

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.

 Page 1 of 1