It's not easy, mostly because it's difficult to get the same random
number.

If you're willing to use two columns, it's easy:

A1: =MID("BINGO",INT(B1/15)+1,1)
B1: =INT(RAND()*75)+1

In article ,
"T Harris" wrote:

This will be easy for most but not me. Here goes:

I want Excel to simply generate a random number between 1 and 75 ( I know
how to do this part) like in BINGO, if the number is between 1 and 15, show
"B15" if 15 was to be generated. Since I in BINGO contains the range
16 -30, then I need any number that occurs randomly between 16 and 30 to
show as "I23" if 23 was the generated random number. N contains the range
31-45, etc.,

I can do it manually now and just add the correct letter myself but that
takes the fun out of it. Can anybody tell me what I do. I didn't even know
the name of the feature I needed to look up to get help on. Thanks.

T Harris