Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calling the contents of a random cell
Hi. I have a spread sheet with 90 values in cells L1 through L91.
I am using =int(rand()*91+1) to generate random integers from 1 to 91. I then want cell C3 to display the contents of L** depending on which random number was called (so if it give me 10, C3 should display the contents of L10). Could anyone tell me how is best to do this. I can't use nested IF statements as I have too much information in the list. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup only calling one cell | Excel Discussion (Misc queries) | |||
Calling cell values from random sheets from a base sheet | Excel Worksheet Functions | |||
Random scramble cell contents | Excel Worksheet Functions | |||
Some (somewhat random) cell contents not printing | Excel Discussion (Misc queries) | |||
Calling procedure when leaving cell | Excel Worksheet Functions |