pick3

[piter]

Please help me in the following =
Create a planilia in Excel, to create pairs with the smallest to the largest digit
Example 457 = pair with the smallest and largest digit = 47. But obeying the three positions in pick3
In the example under 4 digits 1 and is positioned higher in the 3rd position, the digit
In the middle goes like this case is 4:07 = 5.6. gave 5
= 749 Another example is the smallest 4-digit top nine of the pair taking the 2nd position and three
The seventh digit was between 4 and 9 = 5,6,7,8
Purpose of the macro is to create pairs in three positions pick3 rotation with the lowest and highest digit
The third digit is the lowest and highest type OK to filter the smaller more
Use the registration of designs and see the positions of the lower frequencies for more
It may just be ok to create the macro. thanks
pick3
1 st 2 nd 3 rd
4 5 7
7 8 9 ...
here's the list of registered sweepstakes picks opçap copy and paste or type!

 

[piter]

Hello, can you help me on the question of ownership of these
pairs =
01 10
02 20
03 30
04 40
05 50
06 60
12 21
13 31
14 41
23 32
24 42
15 51
25 52
34 43
25 52
35 53
45 54
These pairs are a basic change is to create the macro Randon combination
Of 4 numbers, but only one example of the numbers of pairs
35,53,45,15 = this combination can not because 35 to 53, or number of the sum tends to be double
Another example 12,25,35 = 42 can this example because it has a number of each pair palindrome, then, are groups of four but can not polindromos the couple, only one pair of the couple. Making all pairs of the list ok
= 12,21,32,41 because you can not 24:21
= 12,32,25,41 can
Excel 2010, windows7
<!-- / message -->
<!-- / message -->
<!-- / message -->

 

[piter]

Hello, can you help me on the question of ownership of these
pairs =
01 10
02 20
03 30
04 40
05 50
06 60
12 21
13 31
14 41
23 32
24 42
15 51
25 52
34 43
25 52
35 53
45 54
These pairs are a basic change is to create the macro Randon combination
Of 4 numbers, but only one example of the numbers of pairs
35,53,45,15 = this combination can not because 35 to 53, or number of the sum tends to be double
Another example 12,25,35 = 42 can this example because it has a number of each pair palindrome, then, are groups of four but can not polindromos the couple, only one pair of the couple. Making all pairs of the list ok
= 12,21,32,41 because you can not 24:21
= 12,32,25,41 can
Excel 2010, windows7
<!-- / message -->

 

[piter]

Hello, can you help me please. and a lotto 60 / 6 ok
The macro has the following to make a list of results, and the option to add or update the list, sort the results in another column as I select the 1st number
Example = I numalista all results that start with the number 01 or the number I choose, thank you for helping
43 44 46 53 54 59
03 16 23 25 51 56
02 10 15 44 56 57
08 19 46 51 52 54
07 14 15 20 23 35
03 05 11 36 44 46
06 19 22 34 43 45
07 10 32 43 47 54
07 08 24 30 33 47
07 12 25 26 32 39
08 09 14 32 53 59
07 09 12 19 45 54
05 20 22 28 29 30
01 04 26 39 43 49
38 42 44 52 58 60
01 27 29 38 50 52
08 13 25 34 42 48
06 13 29 30 35 37
11 14 16 28 34 46
04 05 16 18 27 51
17 24 25 38 41 55
10 47 51 53 59 60
10 21 43 47 53 55

 

[piter]

My brain seems to have taken a vacation. using all 10 digits, any digit can be in any position but can only be used once per combination. how many unique combinations are there? do you have program code to generate these unique combinations?

 

[piter]

Hello, please help me so
From 00000 to 99999 and then the macro should add example
One of the combinations is = 2,3,5,6,8, = 24
So do 0,000 to 99,999 and add each line
00000
00001
...

 

[piter]

Hello. Please help me create a macro with the table of 000,999 (thousand)
Next two columns where I write down 0 1 prize in the table of one thousand hundred will be highlighted in color, and another column of the fifth prize
example
1st column 2nd column table may be hundreds of thousand in 20 columns
158 green 279 blue
.... ....

Undo edits

 

[piter]

Hello, are a lottery results 23 60/6 has a macro to do so
05 07 42 46 50 60 0x 1x 2x 3x 4x 5x 6x 7x 8x ...
19 20 31 42 51 56 27
08 19 21 36 42 59
07 17 19 26 40 50
12 32 40 47 48 59
09 19 45 46 54 56
07 12 38 39 45 56
09 19 20 50 51 60
03 04 29 36 45 55
13 33 36 41 50 56
09 18 24 35 36 59
03 11 13 27 32 47
02 08 38 42 48 49
11 17 24 39 46 49
06 13 21 22 31 46
01 19 24 26 52 55
03 15 16 35 37 47
06 10 12 17 28 53
02 16 17 25 50 54
23 27 30 37 38 44
02 12 19 22 36 58
25 35 42 45 52 57
10 13 20 40 44 56
The macro has to count and put in the proper column example the number 27 then put out four times in column 27, the column of zero times, it means that is not out yet not once,
Option to increase the list of sweepstakes and columns 8,9,10 etc ...