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

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

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
.

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