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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
=indirect("G"&round(rand()*(10-1)+1,0))
or
=index(g1:g10,rand()*(10-1)+1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A different kind of VLookup 8
Formula for showing warnings when cells are out of range. 1
variable question 3
reffering another cell value which contains RAND() 0
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Function 6
Scrabble Value calculation for Welsh words 0
i need more help with this time question 5

Back
Top