How about: [B1] = OFFSET(A1,RANDBETWEEN(0,2),0)

You'll need to change the "2" to be the last row of the list you're picking from.

Bill
---------------------------
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?