Random cell generator

J

JK2

I would like to set up a program that randomly selects a cell in a range of
eight cells.
Can anyone help?
 
D

Dana DeLouis

...randomly selects a cell in a range of
eight cells.
Click to expand...

Here's one idea. It randomly picks a cell from A1:A8. Adjust as necessary.

=OFFSET(A1,INT(RAND()*8),0)
 
Top