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!

 

[Scott Huish]

That should accomodate up to a 10 digit number with a max number of 1 to 9.

 

[piter]

Hello, hotpepper, ok great!, Much better than the staff of Cambridge and Harvard,
Hot Pepper Thanks very good work. Thank you for meeting

 

[Scott Huish]

Here is a sample output from the macro:

Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">0</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">0</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[Scott Huish]

Responding to PM:

What do you have maxNum set to?

For your example it should be 2, because this is the highest number that can appear in any column. It should not be set to 222222.

That is highest number 2 (maxNum), length of 6 (maxLength).

 

[piter]

# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?
# n a m e ?

 

[Scott Huish]

Put the code in a standard module.

In the Visual Basic Editor (VBE), from the menu-- Insert, then Module.
Put the code here.

 

[piter]

Hello, ok, hotpepper, ok! Perfect!, It worked ok! so missed the (0000000), hallelujah! wonder if this formula can be used
It can also be used for letters,? Thanks, good job, that just moves the computer is not easy

 

[piter]

Hello, hotpepper within this table, which was very good, now inside the table
Precisi so =
Has these combinations =
000001
001000
100000
Or
000200
020000
202000
000022...
Dec.02, the macro within the table now she has to take the double conbinaçoes example
001000.000001,. just leave a, because now the position doesn't matter, now I need linear
Without repetition, is for another job, but I will use the two macros, the macro can only leave a conbinaçao another example = 220444, 444202, just leave a row and so with other combinations, the macro will delete it from the relation of the first macro, because I'm going to use now by line, there is no need for doubles, only one is enough. Thank you

 

[piter]

Hello, hotpepper within this table, which was very good, now inside the table
Precisi so =
Has these combinations =
000001
001000
100000
Or
000200
020000
202000
000022...
Dec.02, the macro within the table now she has to take the double conbinaçoes example
001000.000001,. just leave a, because now the position doesn't matter, now I need linear
Without repetition, is for another job, but I will use the two macros, the macro can only leave a conbinaçao another example = 220444, 444202, just leave a row and so with other combinations, the macro will delete it from the relation of the first macro, because I'm going to use now by line, there is no need for doubles, only one is enough. Thank you
<!-- / message -->

 

[piter]

hello=I need a macro to allocate 20 numbers at random order, it must not be in sequins, but total randomness, once 20 numbers(1-20) has been allocated it must suffle it self and start the "Processes" all over but in a different way, again in random order. My numbers will be in Column B1:B2000, and the powerball number must be allocated in column G1:G2000, The macro must only look at column B1:B2000 to count the number of lines it must allocate the "RANDOM", powerball number. Can you help me out please