View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Not sure what "obtaining random numbers based on a set of known random
numbers" means, exactly, but if you have a set of random numbers, you
can use the technique he

http://www.mcgimpsey.com/excel/randint.html

to get a random sampling of them.

Say your randoms were in A1:A100. You could get a random sample of 10 by
array-entering

=INDEX(A:A,RANDINT(1,100))

In article ,
"MaryEng" wrote:

Can anyone provide an effective Excel function for obtaining random numbers
based on a set of known random numbers?