random cell selection from a column of cells

M

MF

This seems like it should be easy.

How do I make a random cell selection from a column of cells?

Regards,

MF
 
S

Shane Devenshire

Hi,

If the cells are in the range A1:A100:

=OFFSET(A1,RAND()*100,)

If there are more or less rows you can change the 100 portion. The down
side is this formula will be returning cell A1 sometimes, which may not be
best if you have a title there or you data starts on a row other than 1. In
that case, for example if your cells run from A5:A105 then use

=OFFSET(A1,5+RAND()*100,)
 
Top