=INDEX($A$4:$A$29,INT(RANDBETWEEN(4,29))-3)

If Randbetween returns 29; the array contains only 26..So adjust as above

If this post helps click Yes
---------------
Jacob Skaria


"Lost in Microbiology" wrote:

I have the alaphabet in column 1 starting at row 4. I would like for a cell
to randomly pick one of the 26 letters of the alphabet. In cell B4 I have the
following formula:

=INDEX($A$4:$A$29,INT(RANDBETWEEN(4,29)),0)

It works, every few refreshes (F9), it will give me a #REF! error. I can not
figure out why. Any help would be appreciated as this is frustrating me.

Thanks.