| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I WOULD LIKE TO RANDOMLY GENERATE FROM LIST I CREATE ON SAME PAGE
i need to have one cell choose between a list of cells i have on the same
page.. i am new to excel and dont know if this can een be done .. help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I WOULD LIKE TO RANDOMLY GENERATE FROM LIST I CREATE ON SAME PAGE
=offset($A$1,trunc(rand()*9),trunc(rand()*9))
would be an example. -- Regards, Tom Ogilvy "totalmaker" wrote in message ... i need to have one cell choose between a list of cells i have on the same page.. i am new to excel and dont know if this can een be done .. help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomly Generate Specific Data | Excel Worksheet Functions | |||
| generate randomly assigned lists | New Users to Excel | |||
| Generate column of 1's and 0's randomly | Excel Discussion (Misc queries) | |||
| How to generate a list of randomly selected numbers within a range | Excel Worksheet Functions | |||
| How can I generate 10 sites randomly from a worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
