Randomly Choose Cells from Colum/Row
In a column next to the column containing the ten data items enter:
=RAND() and copy down. Touch F9 and then sort by the newly entered column.
This will "randomize" your data. Just take the top three cells.
Whenever you want a new sample, repeat the process
--
Gary''s Student
"J" wrote:
hello. i'm not sure if this is possible, but i'm trying to randomly select
multiple cells from a colum to be evaluated. for example, say i have a clumn
of 10 cells. i'd like this function in another cell to select 3 cells from
the 10 at random. is this possible? thanks
|