Instead we can list all the possible “5 cells with numbers and others are empty” combinations of a 9 cells region and select a random combination every time. The function is memoryless and could repeat numbers when called 5 times. Now, excel has a function to generate random numbers between 1 to 9 ( =round(rand()*9,0)), but this is not good for us since each time we call this function we will get a random number between 1 to 9, where as we need a 5 random numbers without repetition between 1 to 9. 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