Lottery Odds for 2 most frequent numbers out of 5 as well as the 3 most frequent numbers out of 5

[rebel123]

Enclosed are examples of the Florida Lotto Fantasy 5 which is 5 numbers
from 1 thru 36.

I am trying to figure out which 2 numbers appear TOGETHER the most frequently
as well as the 3 numbers that appear TOGETHER the most frequently.

The data set is.

1. All time numbers- 9260 results
2. The last 5 year numbers- 1461 results


I need = sign formulas for the areas in green.

 

[Peter_SSs]

I have ab iMac so there is no ALT F11.

That is why I previously wrote:

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[rebel123]

OK cool- I just updated mine to MAC!

 

[rebel123]

ess Alt+F8 to bring up the Macro dialog

 

[rebel123]

OK I now know how to do the process. the code has an error.

Check the image pleez

 

[rebel123]

I did a Google Search and ACTIVEX is not available on mac.... Can someone send the results by uploading it?

 

[rebel123]

I uploaded the file here which is in XLSX format
https://easyupload.io/dhhxx2

Or if you want it in XLSM format it's here-

https://easyupload.io/1gdaer

 

[rebel123]

Or if anyone knows the answers, please post them.
I am only looking for the 3 most common numbers and their probability.

The set has 9,260 rows so if the 3 numbers showed up 15 times, then
the probability would be 15 / 9260 = 0.00161987041

 

[rebel123]

Here are the answers. I paid someone on Fiver to run the VBA.

 

[rebel123]

Thanks @Peter_SSs I have marked this as resolved since you figured out the answer.
I marked this as resolved and solved.

Thank you!

 

[rebel123]

And thanks for your efforts @richh it is now solved.