I am trying to randomly generate a series of numbers based on another series
of numbers. If i have the numbers 1 to 15 sequentially in A1 to A15, then how
do i randomly generate one of these numbers in C1. Currently i am trying -
=RAND()*A1:A15, but this is not working. The numbers in A1:A15 may well
change and this is why i don't want to simply use =RAND()*15