| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to have cell C8 contain contents of Cell G(formula)
=indirect("G"&round(rand()*(10-1)+1,0))
or =index(g1:g10,rand()*(10-1)+1) Skip wrote: Need to have cell C8 contain contents of cell G(=ROUND(RAND()*(10-1)+1,0)) Or something simular. Cell G(1:10) contain strings that I am trying to randomize just one of the 10 into cell C8. I am trying to say " =G(ROUND(RAND()*(10-1)+1,0)) " but this does not work. Can you help?? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
