We will detect in each draw as pairs with the same termination.

[jorel]

We will detect in each draw as pairs with the same termination, in a yellow list that contains all the possible formats, see the quantity of each one that was drawn, objectively see the pair that still have not been drawn, example of the same termination 17 37 or 7 and end the same
https://www.excelforum.com/attachmen...1&d=1719059784

[jorel]

hello , PLEASE!!!

[JohnTopley]

Please Login or Register  to view this content.

2 macros: DEMO2 (Planhila2)faster then DEMO1

[jorel]

ok, hello JOHN, obliged to see the post, but in the list two draws are not separated into pairs, but in the list of two 280 possible pairs, it appears how many times it appears in the draws, do you think that no one needs to separate the draws in pairs?

[JohnTopley]

Don't follow what you mean: I interpreted your request as wanting the number of time "01 and "11" occurred TOGETHER in a any draw i.e. 22 times.

[jorel]

ok this is correct, go to macro, paste all the draws? is that it?

[JohnTopley]

Mhe macro(s) simply loops through the list in M:N and counts the number of times a pair is found in a draw. So changing the list in M:N will simply produced the appropriate count for each pairing.

[jorel]

ok John, now I understand, it's perfect, knowing that every week you will update the list of two draws that will be done automatically, ok conglatulation, thank you