Random Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know if Excel has a formula to do the following: I have a database
of 252 numbers and I need to randomly pick out 10 groups of 30 numbers,
 
Because you need 300 sample of 252 numbers, you will have repeats.

Put your numbers in A1 thru A252

In B1 enter:

=INDEX($A$1:$A$252,RANDBETWEEN(1,252),1)

Then copy B1 and paste from B1 thru L30
 
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

Random Numbers 2
Parameters for Random Numbers 1
Random Numbers and Me 4
random between function 8
random number generator 6
Help Please! Random generator issue. 2
How to make random numbers stay the same 4
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1

Back
Top