=INDEX(B10:B50,INT(RAND()*50)+1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pete Morris" <nospam.ple@se wrote in message
...
I have a range of cells, eg (B10:B50) each cell containing
an integer.

How do I select a random integer that is in one of those cells?


I want a formula in cell so that that cell contains a random value
from that range.