Data Structure

[Robert_Tarver]

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.

[Per_Carlen]

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?

[Per_Carlen]

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

[grosvenordelaro]

Store numbers in a separate table per draw, makes tracking like spotting lunchtime 3 - bonus for today in results history!