please in each draw line do the double trios and quartets.

[jorel]

please in each draw line
do the double trios and quartets
* we have 21 double
we have 35 trios
* and we have 35 quartets
https://www.excelforum.com/attachmen...1&d=1535483407

[Kaper]

Sample results?

[jorel]

ok hello, KAPER
03 05 03 08..... 21formations
03 05 08 03 05 09.... 35 formations
03 05 08 09 03 05 08 19 35.... formations

[jorel]

03 05, 03 08..... 21formations
03 05 08, 03 05 09.... 35 formations
03 05 08 09 ,03 05 08 19 35.... formations

[Kaper]

Please Login or Register  to view this content.

[jorel]

Hmm! very good job KAPER, worked very well and very fast
* conglatulations, when I win a lottery prize will be rewarded,
thank you
* kaper = my lottery is 01 to 31
* the total number of doubles = 465
the total number of cracks = 4,495
the total of the quartets = 31,465
how can we know which doubles, trios and quertets have not yet been drawn? since now we have done in the raffles, to confront with the whole of each group

[Kaper]

List all doubles, triples, quads
Note: they are in a form "01 02 " - with whitespace after last number
And use COUNTIF function to check how many times this one appeared.
Of course if COUNTIF is 0 then it's not used one

[jorel]

but this calculation, does it have in the macro?

[Kaper]

No, I thought you can do it manually.
But macro could do it too:

Please Login or Register  to view this content.

[jorel]

huu! thank you!! KAPER!conglatulations