J
Jooky
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
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