How do you pull a random cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fluffy - 20 Mar 2006 18:04 GMT

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?

Reply to this Message

Gary''s Student - 20 Mar 2006 18:04 GMT

You can use RANDBETWEEN().

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

=CHOOSE(A1,"tom","dick","harry","sam","max","mary","betty","nigel","trevor","tony")

Signature

Gary's Student

> 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
[quoted text clipped - 3 lines]
> use a button (i.e. spin) to generate the first number and that would populate
> the name field?

Reply to this Message