How do I get excel to generate Random nos for my data?
 

I want to randomize my study population. I have a data set from which I want
to select my sample randomly.

How do I get excel to generate Random nos for my data?
 

maybe the fuction RANDBETWEEN could help you it will randomize numbers in an
interval eg.:

randbetween(1,100)

if your data is sequencial it will run.

hope it helps
regard from Brazil
Marcelo

"GC" escreveu:

I want to randomize my study population. I have a data set from which I want
to select my sample randomly.

How do I get excel to generate Random nos for my data?
 

Hello,

Give your data area the name "study_population".

Then select the number of cells which you want to fill with a random
sample and enter
=INDEX(study_population,uniqrandint(COUNTA(study_p opulation)))
as array formula (with CTRL + SHIFT + ENTER).

My UDF UniqRandInt you get he
http://sulprobil.com/html/uniqrandint.html

HTH,
Bernd