How to insert random phrases
 

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

How to insert random phrases
 

Create a new workbook.

On sheet1:
put this in A1:A100:
=rand()
put your phrases in B1:B100

Then in Sheet2
Put this in A1:
=INDEX(Sheet1!$B$1:$B$100,
MATCH(LARGE(Sheet1!$A$1:$A$100,((ROW()-1)*5+(COLUMN()-1)+1)),
Sheet1!$A$1:$A$100,0))
(all one cell)

Drag down to A5 and drag A1:A5 to E1:E5

Each time the workbook recalculates, you'll get a new set of phrases.
(Hit F9 to force a new calc.)

=======
If you search google for "buzzword bingo", you may find a template that's
already been made.




Jooky wrote:

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

--

Dave Peterson