Choosing numbers randomly

A

Aladino

Hi,

I would like to know how can I choose 125 numbers randomly of a table
with 1228 numbers.

Thanks
 
B

Bob I

In a helper column enter =RAND(), then sort on that column and use the
first 125 rows.
 
D

Dave Peterson

If your 1228 numbers are in a range like: A1:A1228
then you could put:
=rand()
in B1:B1228

Then sort both columns by column B.

And use the values in A1:A125
 
Top