Choosing numbers randomly

  • Thread starter Thread starter Aladino
  • Start date Start date
A

Aladino

Hi,

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

Thanks
 
In a helper column enter =RAND(), then sort on that column and use the
first 125 rows.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a column of pseudo random numbers with probability ' 2
MACRO RUN random percentage and copy of column values 1
Generate Correlated variable to an existing data set 2
Create random list - dublicates are okay but not right after each other 2
Can't Explain N/A in Vlookup 2
PC often crashes, at the beginning or after pixels appear 3
Use Numbers in Specific Cell 1
Numbers better as Text? 7

Back
Top