Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Need help getting data from Word to Excel | Excel Discussion (Misc queries) | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |