In B1 enter =RAND() and copy down to B3.

Then sort columns A&B by B; this will "shuffle" the order of the items in A.

Pick the first item in column A
--
Gary''s Student


"capnsean" wrote:


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