Welcome Guest
You last visited December 7, 2016, 7:22 am
All times shown are
Eastern Time (GMT-5:00)

# Combinations by number position

Topic closed. 3 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 2, 2010, 11:19 pm - IP Logged

Hello,

I'd like to know if someone has or can create this very useful excel file of 5/56 combination by number position,with their lexicographic number on front of each combination,there is a total of 260 numbers by position according to the table chart of " WINSUMLOOSESUM " who was kind enough to give to me which is :

Don't mind the 45 and circle that was from a previous post.

It would look like this if someone were to do it.

firstable all columns would be at width : 15.

Details for the file display.

For position 1.

1.  Cell A1 and B1 would be " merge " together with in it : Position  1.

2.  Row 2 would be empty.

3.  Cell A3 and B3 would also be " merge : with the number 1 in it.

4.  Row 4 would be empty.

5.  Cell A5 would have the word :   Lexicographic      in it.

6.  Cell B5 would have the word :    Combinations     in it.

7.  Row 6 would be empty.

8.  Cell A7 and up would have the lexicographic numbers list from the combinations of the column B.

9.  Cell B7 and up ( column ) would have all the combinations for the number 1 " as position1 ".

It should look like this :

For all the numbers as " position 1 ".     (1 to 52)

It will start at columns : A,B with number 1 and will stop at columns : CY,CZ with number : 52.

For all the numbers as " position 2 ".     (2 to 53)

It will start at columns : DA,DB with number 2 and will stop at columns : GY,GZ with number : 53.

For all the numbers as " position 3 ".     (3 to 54)

It will start at columns : HA,HB with number 3 and will stop at columns : KY,KZ with number : 54.

For all the numbers as " position 4 ".     (4 to 55)

It will start at columns : LA,LB with number 4 and will stop at columns : OY,OZ with number : 55.

For all the numbers as " position 5 ".     (5 to 56)

It will start at columns : PA,PB with number 5 and will stop at columns : SY,SZ with number : 56.

IF I DIDN'T MAKE MISTAKE IT SHOULD BE RIGHT !!!

If someone can write this Excel file,I would realy appreciate  it, Thank you.

Frenchie.

Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: July 3, 2010, 1:23 am - IP Logged

I forgot to mention ,I use Excel 07, which would alow one column per number actualy two with the lexicographic number.

Thank you.

Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: July 13, 2010, 5:26 pm - IP Logged

Hi,

I really need this and hope someone can help ?, I know it's not a easy one.

Thank you.

Los Angeles
United States
Member #75410
June 2, 2009
479 Posts
Offline
 Posted: July 14, 2010, 3:47 pm - IP Logged

Hi,

I Hope it help to get the job down ?

Here is the macro that generate all the 5/56 combinations :

Option Explicit
Dim A As Integer, B As Integer, C As Integer, D As Integer, E As Integer
Dim N As Long, nMinA As Integer, nMaxE As Integer

Sub List_5x56Comb()

' Macro to list combinations in an Excel sheet
Sheets("List556Combos").Select
Range("A1").Select
Application.ScreenUpdating = False
N = 1
Selection.ColumnWidth = 15
ActiveCell.Value = "Combinations"

' Change minimum value for A or maximum value for F
' to cover range of values to be covered
nMinA = 1
nMaxE = 56

' Start of loops for 5 variables (A-E)
For A = nMinA To nMaxE - 4
For B = A + 1 To nMaxE - 3
For C = B + 1 To nMaxE - 2
For D = C + 1 To nMaxE - 1
For E = D + 1 To nMaxE

' Verification of number of combinations posted
' and move to top of next column if 65,000
If N = 65001 Then
Selection.ColumnWidth = 15
N = 1
ActiveCell.Offset(-65000, 1).Select
Application.ScreenUpdating = True
Application.ScreenUpdating = False
ActiveCell.Value = "Combinations"
End If

' Copying the combination in the form N1-N2-N3-N4-N5-N6 in a cell
ActiveCell.Offset(1, 0).Select
N = N + 1
ActiveCell.Value = Application.WorksheetFunction.Text(A, "00") & "-" _
& Application.WorksheetFunction.Text(B, "00") & "-" _
& Application.WorksheetFunction.Text(C, "00") & "-" _
& Application.WorksheetFunction.Text(D, "00") & "-" _
& Application.WorksheetFunction.Text(E, "00")

Next E
Next D
Next C
Next B
Next A
Application.ScreenUpdating = True
End Sub

And if you go in : Mathematics Forum.

Combinations count.

in the 7th post down you can find the link to an excel file that count the combinations by position given by " JADELottery " Thanks again JADE.

Forget about the heading I describe as long as the file show all combinations per position per number with the lexicographic number,I know it's not an easy one that's why I don't have answer so far !!! I'm trying.      ( I work on Excel 2007 )

Thank you.     Serge.

 Page 1 of 1