![]() ![]() ![]() You can download the zipped Bingo Card Excel file, from my web site.The cards are formatted to print three per sheet, on letter sized paper.Īfter you print each set of three cards, press the F9 key to generate a new set of numbered cards. With all that randomness (is that a word?), the 3 cards should never be exactly the same. ![]() The same number might appear on all three cards, but each card uses a separate lookup table of random numbers. On the three bingo cards, an INDEX/MATCH formula pulls the numbers from the random number tables.You can read more about the INDEX and MATCH functions on my website.įor example, this formula is used in cell E2: When you press the F9 key, the sheet recalculates, and those random numbers change. In each set, there are typed numbers 1-75, with the formula =RAND() in the adjacent column. To generate the random numbers, there are three sets of lists on the Numbers sheet. You’ll need one of those numbered ball popper machines though, or create a number selector in Excel. In this example, there are three cards, each with a set of random numbers. To liven things up, you could create bingo cards in Excel, and organize a game during the lunch hour. It’s Friday, and things are slow at the office. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |