4 groups

[jack]

Hello, lt and pab, excellent initiative, I need this macro is a lottery of 60/6
I will divide into 4 groups of 15 numbers, I need the macro to calculate each group of fifteen
Hot = 3 average numbers 5 and 7 cold numbers. From each of the four separate groups
So the macro searches the list of sweepstakes past, then defines the 4 groups of 15 numbers, and then see each groups mean hot and cold, and late

 

[jack]

Hello, we have a list of sweepstakes and 4 groups
In macro have the option of upgrading more sweepstakes go,
The 4 groups seram always the same fixed groups ok
4grupos
01 02 03 04 05 11 12 13 14 15 21 22 23 24 25
06 07 08 09 10 16 17 18 19 20 26 27 28 29 30
31 32 33 34 35 41 42 43 44 45 51 52 53 54 55
36 37 38 39 40 46 47 48 49 50 56 57 58 59 60


results =
09 26 34 43 53 54
11 12 25 33 48 54
02 09 10 21 27 38
13 16 20 26 39 42
07 08 27 31 32 51
03 14 17 32 37 39
07 10 17 24 38 57
18 29 31 42 43 53
04 19 20 24 39 43
06 19 26 47 50 58
18 29 40 42 50 54
08 12 32 44 46 48
06 08 24 37 41 45
13 15 33 45 54 55
21 37 44 46 49 57
26 36 40 46 49 51
03 19 22 24 35 49
05 12 45 52 56 59
07 08 10 12 27 56
17 21 30 48 52 58
02 11 16 18 36 45
19 31 39 44 53 59
02 05 13 17 39 44
03 08 21 25 27 43
03 07 15 29 38 60
07 16 29 36 38 50
06 15 18 24 30 44
08 39 44 47 53 56
07 15 19 34 37 55
09 12 22 39 48 60
02 19 22 30 46 52
05 09 13 33 40 54
16 24 25 42 45 59
04 13 14 40 46 52
03 18 22 34 55 58
04 15 45 47 50 52
01 13 23 24 30 57
22 23 26 37 38 48
07 14 31 33 36 49
02 34 35 42 43 55
02 06 28 36 51 56
17 29 36 38 53 56
12 13 20 30 34 49
12 20 32 48 52 54
02 05 27 28 48 55
05 19 32 41 49 58
06 13 24 32 40 51
01 19 28 33 39 41
01 25 29 36 56 60
02 06 18 30 52 56
26 27 31 38 44 45

 

[PAB]

Hi Jack,

A lottery of 6/60.
I will divide into 4 groups of 15 numbers, I need to calculate each group of fifteen numbers.
Hot = 3 numbers, Average = 5 numbers and Cold = 7 numbers from each of the four separate groups.

The 4 groups are always the same fixed groups:-

01 02 03 04 05 11 12 13 14 15 21 22 23 24 25
06 07 08 09 10 16 17 18 19 20 26 27 28 29 30
31 32 33 34 35 41 42 43 44 45 51 52 53 54 55
36 37 38 39 40 46 47 48 49 50 56 57 58 59 60

I have obviously edited your quotes above to make them more understandable for other readers.

You don't need a Macro to do this, formulas will work just as well if not better.
Firstly, let's assume that your Lotto results are in cells A6:F1006.
Do the following in the order they are:-

(1) In cells H6:H20 enter the numbers from your first group:-
01 02 03 04 05 11 12 13 14 15 21 22 23 24 25

(2) In cells L6:L20 enter the numbers from your second group:-
06 07 08 09 10 16 17 18 19 20 26 27 28 29 30

(3) In cells P620 enter the numbers from your third group:-
31 32 33 34 35 41 42 43 44 45 51 52 53 54 55

(4) In cells T6:T20 enter the numbers from your fourth group:-
36 37 38 39 40 46 47 48 49 50 56 57 58 59 60

(5) In cell I6 enter the formula...

=COUNTIF($A$6:$F$1006,H6)

...and copy down to cell I20.

(6) In cell J6 enter the Array formula (Ctrl-Shift-Enter)...

=INDEX(H$6:H$20,MATCH(LARGE(I$6:I$20+ROW(I$6:I$20)/100000,ROW(A1)),I$6:I$20+ROW(I$6:I$20)/100000,0),1)

...and copy down to cell J20.

(7) Copy the formulas in cells I6:I20 to cells M6, Q6, U6

(8) Copy the formulas in cells J6:J20 to cells N6, R6, V6

This gives the results for EACH GROUP of the FIRST THREE numbers being the HOT numbers, the next 5 numbers being the AVERAGE numbers, and the LAST SEVEN numbers being the COLD numbers.

What you could do then using conditional formatting is colour code them for HOT, AVERAGE & COLD numbers .

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, pab, excellent, very good job, thank you, so the question is this is a lottery 60/6, was divided into 4 groups, the macro is bound to register the sweepstakes from 01 to 60, like 4 lotteries Figures 15, the macro examines each
* Group separately, was very good ok, thanks pab

 

[PAB]

Hi Jack,

I am glad it is what you wanted and it has answered your request.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

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 53
02 24 26 32 35 50
12 27 37 44 54 59
02 07 13 29 38 43
10 21 26 29 32 38
05 16 24 32 38 46
02 04 05 27 49 59
03 04 08 11 47 49
03 36 40 46 58 60
07 27 39 52 55 57
06 21 28 31 33 43
14 25 28 45 53 58
09 11 21 49 53 54
02 05 12 13 25 35
02 05 17 18 54 59
05 12 36 45 50 58
03 14 52 55 57 60
11 27 30 40 44 57
05 13 16 17 27 55
07 09 23 44 46 55
02 18 30 31 45 56
27 35 36 37 42 59
12 28 38 39 51 56
18 27 32 43 50 52
22 29 31 43 50 54
01 16 28 39 44 57
04 19 27 28 29 31
07 12 19 34 40 53
02 08 12 28 33 43
04 18 24 28 39 44
11 16 24 35 46 50
05 11 17 19 44 48
29 48 52 54 55 58
03 04 07 15 27 56
14 32 33 40 42 51
34 39 43 56 57 60
09 26 34 43 53 54
11 12 25 33 48 54
02 09 10 21 27 38
13 16 20 26 39 42
07 08 27 31 32 51
03 14 17 32 37 39
07 10 17 24 38 57
18 29 31 42 43 53
04 19 20 24 39 43
06 19 26 47 50 58
18 29 40 42 50 54
08 12 32 44 46 48
06 08 24 37 41 45
13 15 33 45 54 55
21 37 44 46 49 57
26 36 40 46 49 51
03 19 22 24 35 49
05 12 45 52 56 59
07 08 10 12 27 56
17 21 30 48 52 58
02 11 16 18 36 45
19 31 39 44 53 59
02 05 13 17 39 44
03 08 21 25 27 43
03 07 15 29 38 60
07 16 29 36 38 50
06 15 18 24 30 44
08 39 44 47 53 56
07 15 19 34 37 55
09 12 22 39 48 60
02 19 22 30 46 52
05 09 13 33 40 54
16 24 25 42 45 59
04 13 14 40 46 52
03 18 22 34 55 58
04 15 45 47 50 52
01 13 23 24 30 57
22 23 26 37 38 48
07 14 31 33 36 49
02 34 35 42 43 55
02 06 28 36 51 56
17 29 36 38 53 56
12 13 20 30 34 49
12 20 32 48 52 54
02 05 27 28 48 55
05 19 32 41 49 58
06 13 24 32 40 51
01 19 28 33 39 41
01 25 29 36 56 60
02 06 18 30 52 56
26 27 31 38 44 45
Hello, pab, a lottery 60/6, you can study this?
The base or pivot of the study is the first record of the outcome of the lottery 60/6
Then 60 numbers from 01 th to 60.
Example the number 01, after appearing in a lottery, sweepstakes reappeared after 35
It is an example, do so with the other 59 numbers,
Pab what I need to do amcro, you see after appearing in a particular draw how long (how many draw back to look again, (each of the 60 numbers)
Another example the number 13, went into a draw, voltos to look after 20 draws
You make a lists of 60 numbers beside the register sweepstakes

 

[PAB]

Hi Jack,

Do you know how to use Excel or VBA???

What I would suggest is that you setup an HLOOKUP table next to the draw results that shows ONLY the numbers from 1 to 60 that have been drawn in each individual draw, but instead of putting the actual numbers put the actual draw number.
Then take the last draw each number was drawn using the MAX function and subtract it from the total draws to date to give you the number of draws since each number has been drawn. This is called a Skip Table.
Then all you need to do is to create an HLOOKUP formula for each of the numbers in each of the four groups to give you the number of draws since each number has been drawn.

There are many posts on this forum that discuss Skip Tables so you could do a search and read the posts.

I hope this helps and good luck!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Ok, pab, know very little about excel and vba, ok I'll try, thanks

 

[PAB]

You're welcome Jack.

 

[jack]

Hello, ahh! I'm not getting!!, Mount the jump of each separate group
Example, the number 13 in the 1st group, need to know when he returned after leaving one time when he returned, and so with the 15 numbers of the group, I am not able to do, can you help me please, thank you

 

[PAB]

Hi Jack,

Example, the number 13 in the 1st group, need to know when he returned after leaving one time when he returned, and so with the 15 numbers of the group, I am not able to do, can you help me please, thank you.

I assume by your comment above that you have setup the HLOOKUP table OK?
So basically you are just after the formula to know how many each of those numbers in Group1 have skipped until last being drawn?
Basically, you want to use a the formula similar to this:-

=HLOOKUP(J6,$AC$4:$CJ$5,2)

Where the J6 is the FIRST HOT number in Group1, the $AC$4:$CJ$5 is the HLOOKUP table dimensions and the 2 is the HLOOKUP OFFSET VALUE, assuming that the numbers to HLOOKUP are in the row above.
Then just copy the formula down for the rest of Group1.
Do the same for the other THREE GROUPS.

Obviously you will need to change the criteria within the formula to suit your particular needs.

I hope this helps and good luck!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, ok good job, I have Excel 2010, Windows seven, you can assemble a planilia, as you did in vtrac, and put in mediafire, ficari grateful, or as you put it in a post mount planilia excel and put the link in post

 

[PAB]

Hi Jack,

Hello, OK good job, I have Excel 2010, Windows 7, you can assemble a planilia, as you did in vtrac, and put it in MediaFire, ficari grateful, or as you put it in a post mount planilia excel and put the link in post.

Firstly, did you actually do as I suggested below:-

This is called a Skip Table.
There are many posts on this forum that discuss Skip Tables so you could do a search and read the posts.

If you did, then you should understand what a Skip Table is and be able to set it up in Excel using formulas to create the HLOOKUP table that I mentioned.

I think the best thing you can do is to upload the Excel file you have created using MediaFire so I and anyone else following this thread can view and give feedback and suggestions to.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, I just could not do pab!, But I think it has to do two planilias
An average planilia with hot and cold, and another with the same 4 groups do heels

 

[PAB]

Hi Jack,

Hello, I just could not do PAB!

I enjoy being able to help people achieve what they are after, it is very satisfying.
As you can appreciate, setting up SpreadSheets and answering questions takes time.
That being said, although I am happy to help people, they must also put some time and effort in themselves by doing research to try and find the answer for themselves. Unfortunately, I have seen no evidence from you in this thread that you have tried to accomplish this yourself, or indeed in other threads that you are currently involved in.

I would strongly suggest that you do the following:

(1) Google How to setup a Skip Table in Excel or similar words.
(2) Google How to create formulas in Excel or similar words.
(3) Google How to setup an HLOOKUP table in Excel or similar words.
etc. I think you get the idea.

If everybody does all the work for you then you will not learn and will always be fully dependant on the help of others. If you can get to a stage where you are able to do things for yourself, you will find that people will be more willing to help you, rather than knowing that they will have to do all the work for you.
The other thing is that when you ask a question and it is answered, as I have done in this thread, you want numerous other things added, this all takes time and effort of the person giving up their FREE time to help you.
Being able to do things for yourself is very satisfying and gives you a sense of achievement.
Please follow my suggestions above and do some Googling, and when you have put something together in a SpreadSheet I will be happy to look at it for you.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, pab agree with you, but the post is of help, I have little time to see on google,
Then you're not working for free, because when I will win 20% of the prize too, there are people with more talent and old, who had opportunity to learn
They can help the younger ones, not everyone can learn excel, but I agree with you

 

[PAB]

Hi Jack,

Then you're not working for free, because when I will win 20% of the prize too, there are people with more talent and old, who had opportunity to learn.

I don't understand what you mean?

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

hello, here is easy pab have 45 pairs of políndromos (double inverted)
the formation of the trio, the couple can not have instance 01.10
tend to have 01 or 10 numca the two together
eg formation of trios 01 23, 45
the formation of trios can not have polindromos and repeating digit in its composition
example = 01,23,45
01,21,10 = this training because you can not polindromo and has the digit one (1) formçao delete this, can not appear to generate a 1000 or more formations. Thanks pab
01 10
02 20
03 30
04 40
05 50
06 60
07 70
08 80
09 90
12 21
13 31
23 32
14 41
15 51
24 42
25 52
34 43
16 61
26 62
35 53
17 71
27 72
36 63
45 54
18 81
19 91
28 82
37 73
46 64
47 74
57 75
48 84
39 93
49 94
58 85
68 86
59 95
78 87
69 96
79 97
89 98
56 65
29 92
38 83
67 76

 

[PAB]

Hi Jack,

Didn't want to answer my question then???

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[jack]

Hello, pab, which question? Please I need the macro to the trios
Provided = polindromos and there can be no repetition of digits in your formçao
Ok, as your question, forget it, I got on another forum, MREXCEL (UK)