=INDEX(A1:A10,INT(RAND()*10)+1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"hbb2699" wrote in
message ...

I have a spreadsheet that has a group of peoples names on it. I want to
be able to create a formula that will cause it to randomly choose one
of those people on the list. I know there is a way to create a formula
for this but I completely clueless on how I would type the formula in.
Can anyone help me with this? Thank you!


--
hbb2699
------------------------------------------------------------------------
hbb2699's Profile:
http://www.excelforum.com/member.php...o&userid=35224
View this thread: http://www.excelforum.com/showthread...hreadid=552313