![]() 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. |