Random function

[Chris]

Hi, can someone please advise me how to create a spreadsheet that
generates random responses from a given source (data area on the
spreadsheet). I am trying to create for a United Way charity event, a
callers card for the game "Bingo". In essence, the "caller" would use
the s/s to generate the following individual (i.e. each time the sheet
is recalculated) alpha numeric responses:

B = 1-15 (i.e. B1, B2, B3 ………. B15)

I = 16-30

N = 31-45

G = 46-60

O = 61-75

I'm sure this should be fairly straighforward, but I am unable to find
the right (or understandable) MS references to explain how to
construct this function.

Can anyone please help.

Many thanks

 

[Peo Sjoblom]

For B1 to B15

=INDEX($B$1:$B$15,INT(RAND()*(15-1)+1 ))

do the same for the other ranges, i.e. for G

=INDEX($G$46:$G$60,INT(RAND()*(15-1)+1 ))

 

[Jerry W. Lewis]

=RANDBETWEEN(1,75) or =CEILING(RAND()*75,1)

If you want to avoid repeats, then put 1 through 75 into one column and
=RAND() in corresponding cells of a second column. Sort both columns by
the second and then call numbers from the sorted first column.

Jerry

 

[L. Howard Kittle]

Hi Chris,

I'll send you a workbook that does a BINGO call. Picks the numbers in a
randon method and does a few other things.

HTH
Regards,
Howard