Hi!
Here's one way if you're only using a "small" range of
cells:
=INDEX(A5:A10,MATCH(RANDBETWEEN(1,6),{1,2,3,4,5,6} ,0))
Note that RANDBETWEEN is a volatile function and the value
returned will change every time the wb calculates.
Biff
-----Original Message-----
How do I create a RAND or RANDBETWEEN function (or
similar) to display a
random value from a group of cells? ie. =randbetween
(a5:a10)
.
|