detect in the 4 columns the pairs that are drawn the most (their frequency).

[jorel]

detect in the 4 columns the pairs that are drawn the most (their frequency)
then see the delays but only of the pairs with the highest number of times that were drawn
https://www.excelforum.com/attachmen...1&d=1641891216

[Kaper]

As you were looking for first 2 numbers from of each quadrant in columns A:AF then it is natural that most frequent are
01 02 (79 occurences)
06 07 (also 79)
51 52 (73 occurences), and
56 57 (66)
Simple formula COUNTIFS is used for that (AV4: =COUNTIFS(V$5:V$2212;AT4;W$5:W$2212;AU4) and copy down and each 3rd column right) and finding max is done with INDEX(MATCH(MAX ... see top row abowe pairs lists

The code in the file was for generation list of all pairs (you listed ca 105 from each quadrant in columns AT:BD) while there are 300 possible pairs.

The code for 3rd quadrant:

Please Login or Register  to view this content.

[jorel]

ok great job KAPER, we have pairs that were drawn 79 times and zero times, a lot of work, thanks

[Kaper]

we have pairs that were drawn 79 times and zero times

That is not true.

You were asking for the pairs which appeared as a first two results from a given quadrant.
That is why a lot of pairs with large numbers like 43 and 44 or 99 and 00 etc. have 0 count (or almost 0).
It does not mean that such pairs were not drawn. They were simply not first numbers from their quadrant.

Note that in all 4 quadrants the most common pair is a first pair.

If you look for ANY pair frequency it will be pretty similar number (but it is another topic/thread and I think it has been already answered some time ago - please search your old threads)

[jorel]

ok kasper, if you are correct, we have to observe this, you are correct, so if i hit the 4 initial doubles i'm in if i'm wrong i'm out just like that, thanks KAPER