Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to find an easy way to solve this problem. What I want to
do is: Short Explanation - I have 100 text phrases and I want excel to randomly pick 25 of these phrases and insert those 25 into a 5 by 5 grid of cells. Without duplicates. Long Explanation - I'm making a BINGO game to play while watching football. After watching about 10,000 football games I came up with 100 things that usually hapen 2 or 3 times a game. Put them in a grid of 25 and then as you watch the game yell out what you have on your card when you see it. I have been manually picking these things and inserting them in the squares but to do this on a large scale will be very time consuming. Thanks in Advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Sampling | Excel Discussion (Misc queries) | |||
VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |