Forum Discussion
New to Excel
Hello, I'm fairly new to excel. It's always been a challenge to create a spreadsheet. My participants from programming remotely are challenging me to create bingo cards. The issue is each of them hav...
A standard way of achieving this is to use RAND or RANDARRAY to associate a random number with every possible Bingo number. Then ranking the occurrence of each random number within the helper range gives a list of unique numbers in random order.
= RANK.AVG(randNum, randNum)
Use as many as you need.