Choosing numbers randomly

[Aladino]

Hi,

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

Thanks

 

[Bob I]

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

 

[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

 

[herochenna]

Visit www.ExcelGoodies.Com

 

[Aladino]

Hi,

Thank you very much to all of you. That was great help.