random cell selection from a column of cells

  • Thread starter Thread starter MF
  • Start date Start date
M

MF

This seems like it should be easy.

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

Regards,

MF
 
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,)
 
Back
Top