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,HOTPEPPER=Checking: the macro should do this, hotpepper
have to correct the formula to do this, ok

- Take in column A 43 19 22 36 25 11 49

- The macro should do in column B 44 20 23 37 12 50

- And in column C 45 21 24 38 13 01
- ... And in column D. ATE 50 COLUMNS






The macro does not do that .... she simply fills in the columns with 50 numbers from 01 to 50, varying according to what is filled in column A. ... but it looks like this:

Column A 44 20 23 37 12 50

Column B 04

Column C 05

...

Column AZ 04

 

[Scott Huish]

I think part of the problem is you are asking for 2 different things:

789 should generate 79 as per your first requirements, but this is out of your range of the numbers 1-50. Please clarify.

 

[piter]

Hello, HOTPEPPER, of course, are two very different things, you made a second, the lottery is
Pick3 and this is now euromilhao lottery, a lottery is 50 / 5 from Europe, but are 7 numbers, because it is a search hotpepper are very different things, would have to open a new topic? You can not link with the pick3! It is another matter ok thanks

 

[Scott Huish]

You never said it was a different thing. So, is the first macro complete?

Are there only 7 numbers for the second macro?
You can use the same method as I added to the first one to do this, just change the ranges.

And 1 topic per thread would be good.

 

[piter]

hello hotpepper = ok lets start again is a lottery
pick5 (50 / 5) = There are 50 columns in a spreadsheet, each column has more than 8000 entries (results) of each entry consists of 7 numbers! You have everything in column A, now I want to do is to increase all results in each cell for this column to be increased from 1 in column B, column 2 increased C increased 3 in column D, and so until all 50 columns are increased by one, so when you reach the end of 50 columns and this column if you increase by one, then you would reset the results to the entire column or back to start again!

Column A = 43 19 22 36 25 11 49

Column B = 44 20 23 37 26 12 50 = 1

Column C = 45 21 24 38 27 13 01 = 2
colluna =.... d 50 until the column
hotpepper in column A, I'm putting resuldatos or a list of seven numbers get the macro to each of them starting in column B +1, column A only serves to put
the results of seven numbers, you must have button to call the macro
hotpepper, also can put next to the 50 columns
the option to place the results of euromilhao, which appears in the results as I click on a highlighted color
within the planilia done after the 1st half, sample results euromilhao = 01/2004 02/13/2004 1 1 16 29 32 36 41
2 02/2004 20/02/2004 - 7 13 39 47 50
3 03/2004 27/02/2004 - 14 18 19 31 37
4 04/2004 05/03/2004 1 4 7 33 37 39
5 05/2004 12/03/2004 - 15 24 28 44 47
6 06/2004 03.19.2004 - 33 36 37 42 45
7 07/2004 26/03/2004 - 3 4 10 23 43
8 08/2004 02/04/2004 - 4 12 24 27 36
9 09/2004 04/09/2004 1 1 4 10 19 23
10 10/2004 16/04/2004 - 14 15 28 35 40
11 11/2004 23/04/2004 - 6 10 21 45 49
12 12/2004 30/04/2004 - 5 6 16 23 27
13 13/2004 07/05/2004 - 15 16 21 36 38
14 14/2004 14/05/2004 1 1 3 21 32 39
15 15/2004 05/21/2004 1 15 29 37 39 49
16 16/2004 28/05/2004 - 6 11 35 41 44
17 17/2004 04/06/2004 1 9 13 34 41 42
18 18/2004 11/06/2004 - 2 7 8 10 47
19 19/2004 18/06/2004 2 1 23 28 40 43
20 20/2004 25/06/2004 - 3 21 30 34 35
21 21/2004 02/07/2004 - 4 23 24 28 34
22 22/2004 09/07/2004 - 2 5 12 19 44
23 23/2004 16/07/2004 - 24 26 31 38 50
24 24/2004 23/07/2004 - 7 10 27 31 34
25 25/2004 30/07/2004 - 9 10 19 37 50
26 26/2004 08/06/2004 1 5 15 24 35 44
27 27/2004 13/08/2004 - 20 27 41 43 50
28 28/2004 20/08/2004 - 6 9 10 27 35
NO NEED OF DATA, OK, BJECTIVES AND SEE When you click on the position of the numbers RESULT OF RESULTS

 

[Scott Huish]

So I have to parse out the results?

How many columns do you have? If Column A has 7 numbers and you want 50 columns. That would overlap your values in Column B, etc.

I'm about to give up here, so you need to show exactly how your data looks and exactly what you want. Your first example shows 7 numbers in a column, but then below it shows multiple rows ???? Also per your explanation each part is not broken out into separate cells, it's all one piece

Cell A1: 02/2004 20/02/2004 - 7 13 39 47 50

All in one cell ?(so you need the macro to split the pieces apart?)

How do the 7 numbers in column A fit into this?

I'm sorry I don't get it.

 

[piter]

Hello, hotpepper ok, so forget the 2nd part to include results, do not correct the formula
From yesterday, just add the values​​, leave out the results ok, just fix the formula, thanks

 

[Scott Huish]

Sub test()
With Range("B1:AY7")
    .Formula = "=MOD(A1,50)+1"
    .Value = .Value
End With
End Sub

 

[piter]

Hello ok ok! Hotpepper, very good work, thanks

 

[piter]

Hello, hotpepper, only became part of the formula, you can get corrected, can send whole

That is the whole race formula, because I'm not able to activate the button

Send any formula! please. thanks