Now I could write a function in VBA to do this, but I wanted to do this only using formulas. The problem is now to “generate 15 random number between 1 to 89 and fill them in 15 random spots in a grid of 3 rows by 9 columns such that each row has exactly 5 numbers” I have removed number “90” from the list in order to reduce some complexity in generating the tickets. * The third 20 to 29 and so on up until the last column, which contains numbers from 80 to 90.
* The second column numbers from 10 to 19, * The first column contains numbers from 1 to 9, Each column contains either one, two, or very rarely three, numbers:
Each row contains five numbers and four blank spaces. , contains fifteen numbers, arranged in nine columns by three rows. Read on if you want to know how this is done:Ī typical housie/bingo ticket. Note that these are Bingo UK / India / Australia variant I am talking about, not the US 5*5 type of bingo tickets. To get new set of tickets you would hit F9 (recalculate).Ĭlick here to download the bingo / housie ticket generator. So, out of curiosity I have created an excel sheet that can generate bingo / housie (housey) tickets – 24 of them at a time. That is why whenever I get sometime I experiment with simulating games to know them better. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money.
