Random function
 

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

Random function
 

enter this in a spreadsheet:

=RANDBETWEEN(16,30)
=RANDBETWEEN(31-45)
.....
etc

Cheers,
RADO


"Chris" wrote in message
m...
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

Random function
 

Here is the formula giving the random 1 to 75 value
Put this formula in the B3 cell of your sheet:
=ROUNDDOWN(((75-1)*RAND())+1,0)

And you will have the result in the cell where you will
put this:
=CONCATENATE(IF(B3<=15,"B",IF(B3<=30,"I",IF(B3<=45 ,"N",IF
(B3<=60,"G","O")))),B3)

hope it will help and good luck for your charity event!

-----Original Message-----
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
.

Random function
 

in column A, starting in A1, type in your values

B1
B2
B3
.. . .
B15
I16
I17

etc.


In cell B1, put in the formula
=rand()

then drag fill down the column.

Now sort the two columns with column B as the key. this will give you are
random list of number to be called.

For a new list, sort again as the rand function will generate new numbers
each time you sort.

This method does not produce duplicates. (which would be desirable I would
think)

--
Regards,
Tom Ogilvy

Chris wrote in message
m...
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