Random generated numbers

[Denise Burnett]

I am trying to find a way to generate a list of numbers (1-
75)in random order (for a Bingo game). I can use the Add
In tool 'Random Generated Numbers' but the numbers come
out as a decimal, not whole numbers. When I change the
list to whole numbers, there is overlap in the list.
Please help.
Thanks,
Denise

 

[Dave R.]

A good solution I've read on this group for this is to:

Create a column with the numbers you want (1-75)
in the next column over, enter the formula =RAND()

and copy that formula all the way down, so that each number 1-75 has a
random number (decimal or not, display format usually doesnt matter) next to
it.

Then select both columns, and sort by the random number column. Then you'll
have basically randomized the order of the 75 bingo chips (?), and you can
select the first however many you would in a bingo game (?).

 

[Biff]

Hi Denise,

You might also be interested in this:

http://contextures.com/excelfiles.html

There is a free downloadable sample file on how to create
bingo cards. It's pretty slick!

Biff