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.
HOUSIE TICKETS PRINT DOWNLOAD
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.
0 kommentar(er)
