Another option, placed in any cell:
=INDEX({"alpha";"beta";"gamma"},randbetween(1,3))

(adjust the "3" to be equal to the number of items)

Press F9 to regenerate

Note that Randbetween requires the Analysis Toolpak be installed and enabled
(via Tools Add-Ins)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"capnsean" wrote in
message ...

I -have- searched for a previous post regarding this problem, but came
up with nothing all that useful.

Problem: I need to generate a random item from a list.

I.E.: A1 = alpha
A2 = beta
A3 = gamma
etc.

B1 = RANDOM choice of alpha, beta, or gamma


Any help?


--
capnsean
------------------------------------------------------------------------
capnsean's Profile:
http://www.excelforum.com/member.php...o&userid=25049
View this thread: http://www.excelforum.com/showthread...hreadid=508974