View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jooky
 
Posts: n/a
Default 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