software

I have a list of ten names and need to pull one randomly. Is there a way
that I can put a number 1-10 in a cell and it would randomly return one of
the ten names? as an example if I put the number 2 in the cell it would
populate the cell next to it with Name 1. If I cleared it and put a 2 in
again it would populate the cell with Name 6 this time. Or is it possible to
use a button (i.e. spin) to generate the first number and that would populate
the name field?

You can use RANDBETWEEN().

in cell A1 put =RANDBETWEEN(1,10)
in cell B1 put:

=CHOOSE(A1,quot;tomquot;,quot;dickquot;,quot;harryquot;,quot;samquot;,quot;maxquot;,quot;maryquot; ,quot;bettyquot;,quot;nigelquot;,quot;trevorquot;,quot;tonyquot;)
--
Gary's Studentquot;fluffyquot; wrote:

gt; I have a list of ten names and need to pull one randomly. Is there a way
gt; that I can put a number 1-10 in a cell and it would randomly return one of
gt; the ten names? as an example if I put the number 2 in the cell it would
gt; populate the cell next to it with Name 1. If I cleared it and put a 2 in
gt; again it would populate the cell with Name 6 this time. Or is it possible to
gt; use a button (i.e. spin) to generate the first number and that would populate
gt; the name field?