New to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2137473%22%20slang%3D%22en-US%22%3ENew%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20color%3D%22%23003366%22%3EHello%2C%20I'm%20fairly%20new%20to%20excel.%20It's%20always%20been%20a%20challenge%20to%20create%20a%26nbsp%3B%3C%2FFONT%3E%3CFONT%20color%3D%22%23003366%22%3Espreadsheet.%20My%20participants%20from%20programming%20remotely%20are%20challenging%20me%20to%20create%20bingo%20cards.%20The%20issue%20is%20each%20of%20them%20have%20different%20cards%20from%20different%20companies%20and%20well%20sometimes%20the%20numbers%20don't%20match.%20My%20question%20is%20%22How%20do%20I%20make%20bingo%20cards%3F%22%20I%20have%20completed%26nbsp%3Bso%20far%2C%20%3AB%22%20column%26nbsp%3B1-15%20and%20column%20%22A%22%20should%20be%20random%20numbers%20but%20I%20cant%20create%20random%20numbers.%20I%20appreciate%26nbsp%3Band%20assistance.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2137473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2137637%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F967573%22%20target%3D%22_blank%22%3E%40Birdy1420%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20standard%20way%20of%20achieving%20this%20is%20to%20use%20RAND%20or%20RANDARRAY%20to%20associate%20a%20random%20number%20with%20every%20possible%20Bingo%20number.%26nbsp%3B%20Then%20ranking%20the%20occurrence%20of%20each%20random%20number%20within%20the%20helper%20range%20gives%20a%20list%20of%20unique%20numbers%20in%20random%20order.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%20RANK.AVG(randNum%2C%20randNum)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EUse%20as%20many%20as%20you%20need.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 have different cards from different companies and well sometimes the numbers don't match. My question is "How do I make bingo cards?" I have completed so far, :B" column 1-15 and column "A" should be random numbers but I cant create random numbers. I appreciate and assistance.

1 Reply

@Birdy1420 

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.