Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I look up a number within a string of text | Excel Worksheet Functions | |||
formula that gives me a random number less than other number | Excel Worksheet Functions | |||
Text number to number value for calculating | Excel Worksheet Functions | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions |