Need to have cell C8 contain contents of Cell G(formula)
 

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??

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