Combinations by number position

Reply #3

frenchie — Wed, 14 Jul 2010 19:47:44 GMT

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 = Combin... [ More ]

Reply #2

frenchie — Tue, 13 Jul 2010 21:26:39 GMT

Hi,

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

Thank you.

Reply #1

frenchie — Sat, 03 Jul 2010 05:23:32 GMT

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

Thank you.

Combinations by number position

frenchie — Sat, 03 Jul 2010 03:19:35 GMT

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.... [ More ]