Proper base structure for tracking lottery numbers

I would like to have a database that I could track winning lottery numbers. Should I have a column for each of the numbers? I want to be able to run a summary on the amount of times a particular number is used in a winning combination.

How high does the numbers go and how does a complete winning lottery number look? Can each number occur several times in a lottery number?

BTW, you don’t need Airtable for this. You can do this in Excel or Google Sheets. I made a Google Sheet for Powerball numbers: Powerball number occurences - Google Sheets

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.