Random selection of cells

  • Thread starter Thread starter Suzie
  • Start date Start date
S

Suzie

Let's say you have data in Column A and you want to randomly populate cells
C1, C2 and C3 with data from Column A. Column A could have data in 10 cells
or 100 - you don't know so you'd need to verify the cells selected weren't
empty. And how could you initiate the selection? With a button? By pressing
F9?

HELP!
 
=OFFSET(A1,(RANDBETWEEN(1,COUNTA(A:A))),0)
The above will randomly select data from ColumnA and f9
will refresh. I don't know how to limit the results in
each the 3 cells to unique values that haven't already
been selected in one of the other two cells. Anybody else?
 
Back
Top