Proper base structure for tracking lottery numbers

Topic Labels: Base design
1209 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2
7 - App Architect
7 - App Architect

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