close
I would like to set up a program that randomly selects a cell in a range of
eight cells.
Can anyone help?
--
Cheers
JK2
gt;...randomly selects a cell in a range of
gt; eight cells.
Here's one idea. It randomly picks a cell from A1:A8. Adjust as necessary.
=OFFSET(A1,INT(RAND()*8),0)
--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;JK2quot; gt; wrote in message
...
gt;I would like to set up a program that randomly selects a cell in a range of
gt; eight cells.
gt; Can anyone help?
gt; --
gt; Cheers
gt; JK2
全站熱搜
留言列表
