Lotto/Powerball spreadsheet

[MAJIMBO10]

Hi everyone,

Please note that i have no experience with Excel, However all i want to do it take the last 10 prev draws of our local Lotto and Powerball games and put them in an excel spreadsheet. Then have the numbers listed in order from lowest to highest per draw and then work out which numbers came out for the first time, which numbers came out twice and which numbers came out 3 or more times from the 10 draws.

I would like to do this for our local Lotto games which is 6 numbers between 1-49
and for the powerball which 5 numbers between 1 -45

Can you please assist me with instruction on how to do this.

Your assistance will be most appreciated.

Kind regards,

Linley Julius

[Sisyphus]

Hello majimbo10,
Welcome to the forum!
Imagine a list with 49 columns into which you made 6 marks against the 6 numbers that were drawn, one row per draw.
Imagine another list with 6 columns into which you write the 6 drawn numbers, also one row per draw. I think both lists can give you the same information, but it will be presented differently, and from this difference result preferences. We, here on the forum, can help you once you have one or the other list, or both, and you can point to a cell on your worksheet and ask to produce a certain result in that cell.