Greetings to all with the hopes of a wonderful Christmas Holiday!;
Here is my current situation. I am tracking our WA 6/49 lotto drawings and have recorded all of 2016's draws so far. Here is what I am seeking to
accomplish as I don't remember the function in excel to make this happen;
Draw Date B1 B2 B3 B4 B5 B6 - (This is the header row)
Imagine if you will, drawings totaling 153 draws of past lottery data. Numbers drawn for each lottery ball (obviously). Here's what is tripping me up.
There are 153 numbers each, B1-B6. I would like to find the top 10 numbers by popularity, for each ball. I'm sure this is doable, I just can't remember the
sequence of formula to use.....And thank you to all of you for your help in advance...
Bookmarks