# 4 groups

#### jack

##### Member
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

##### Member
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

##### Member
Hi Jack,

jack said:
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.
jack said:
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

##### Member
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

##### Member
Hi Jack,

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

##### Member
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

##### Member
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

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

#### PAB

##### Member
You're welcome Jack.

#### jack

##### Member
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

##### Member
Hi Jack,

jack said:
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

##### Member
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

##### Member
Hi Jack,

jack said:
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

##### Member
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

##### Member
Hi Jack,

jack said:
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

##### Member
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

##### Member
Hi Jack,

jack said:
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

##### Member
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

##### Member
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

##### Member
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)