Thread: How do I get excel to generate Random nos for my data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote