random number

R

Rob

I am trying to randomly select 20 out of 500 in a data set that I have. I
would like excel to generate the selection.

Thanks
Rob
 
F

Frank Kabel

Hi
one way:
- use a helper column and insert the formula
=RAND()
for all rows
- now sort with this helper column
- use the first 20 entries
 
Top