my new project is to find the most common number Patten's within Keno 1,2,3,4,5,6,7,8,9 and 10 numbers
This example i am finding 5 numbers out of 7 numbers
So you downloaded the past Keno 21 draw numbers and you have your lucky numbers 7 numbers you would like to check
NOTE: you can put up to 31 numbers to check
The VBA code will select the 7 numbers and generate 5 lots of number Patten's to check within the keno numbers to find matching 5 numbers
E.g
| 6 |
12 |
15 |
18 |
19 |
| 6 |
12 |
15 |
18 |
24 |
| 6 |
12 |
15 |
18 |
25 |
| 6 |
12 |
15 |
19 |
24 |
| 6 |
12 |
15 |
19 |
25 |
| 6 |
12 |
15 |
24 |
25 |
| 6 |
12 |
18 |
19 |
24 |
| 6 |
12 |
18 |
19 |
25 |
| 6 |
12 |
18 |
24 |
25 |
| 6 |
12 |
19 |
24 |
25 |
| 6 |
15 |
18 |
19 |
24 |
| 6 |
15 |
18 |
19 |
25 |
| 6 |
15 |
18 |
24 |
25 |
| 6 |
15 |
19 |
24 |
25 |
| 6 |
18 |
19 |
24 |
25 |
| 12 |
15 |
18 |
19 |
24 |
| 12 |
15 |
18 |
19 |
25 |
| 12 |
15 |
18 |
24 |
25 |
| 12 |
15 |
19 |
24 |
25 |
| 12 |
18 |
19 |
24 |
25 |
| 15 |
18 |
19 |
24 |
25 |
and found 6,12,18,19,25 showed up 2 times out of 21 games
this is what the excell sheet looks like : https://1drv.ms/u/s!Ag3gOZ6aEeT_kQu5eMhP9XXH0s6f
almost done but so far its looks good !