Once we select any random 5 cells in a 9 cell row, we will fill them with bingo numbers. The first challenge is to select any random 5 cells in a 9 cell row 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.

Housie game tickets free download