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

G

GC

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

Marcelo

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:
 
B

bplumhoff

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_population)))
as array formula (with CTRL + SHIFT + ENTER).

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

HTH,
Bernd
 
Top