| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random Letter Generator
I have the alaphabet in column 1 starting at row 4. I would like for a cell
to randomly pick one of the 26 letters of the alphabet. In cell B4 I have the following formula: =INDEX($A$4:$A$29,INT(RANDBETWEEN(4,29)),0) It works, every few refreshes (F9), it will give me a #REF! error. I can not figure out why. Any help would be appreciated as this is frustrating me. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Generator | Excel Discussion (Misc queries) | |||
| Random Name Generator | Excel Worksheet Functions | |||
| Random letter and number generator | Excel Worksheet Functions | |||
| random number generator | Excel Discussion (Misc queries) | |||
| Random # Generator | Excel Worksheet Functions | |||
Threaded Mode
