Random function

[Chris G.]

Hi,

I posted this note yesterday however my job related email address will
not allow attachments and suspect that I may have received some
replies that I can't access or read. Thank you very much if you have
responded to my appeal, but can I ask that you resend to my personal
email address ([email protected]). Thanks again, and for ease of
reference my problem is repeated as follows:

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

 

[Jason Morin]

E10:
=INDEX({"B","I","N","G","O"},RANDBETWEEN(1,5))

E11:
=RANDBETWEEN(1,15)+VLOOKUP(E10,
{"B",0;"I",15;"N",30;"G",45;"O",60},2,0)

You must install the Analysis ToolPak to use RANDBETWEEN.
Go to Tools > Add-Ins to install it.

HTH
Jason
Atlanta, GA

 

[Biff]

Hi Chris,

This may interest you. Check this site for a sample
download file that creates bingo cards.

http://contextures.com/excelfiles.html

Look for Bingo Card (near the bottom)

Biff