random number

[Guest]

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

 

[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