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

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

Guest

I want to randomize my study population. I have a data set from which I want
to select my sample randomly.
 
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:
 
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
 

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 number generator 6
Number to word 4
random letter generation 5
Randomly Select cell from filtered list 1
how to randomly select data in excel 4
Pull a Sample from a Population 3
Selecting Random Records From an Excel Sreadsheet 3
can you assign random numbers to many different lines of row? 3

Back
Top