No answer to my last question so i'll try another way:
How can I fill a cell with text from another cell e.g. Kx where x is a random number between 1-10?
Thanks
No answer to my last question so i'll try another way:
How can I fill a cell with text from another cell e.g. Kx where x is a random number between 1-10?
Thanks
Hi,
If you want an actual random number, try this:
="K"&ROUND(RAND()*10,0)
if you want to reference another cell, this,
="K"&A1
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Having now read your post agin - I think you want to select a cell at random between K1 and K10, and return the contents. If this case,
=INDIRECT("K"&ROUND(RAND()*10,0))
Thanks, worked a treat!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks