Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a random sample from a list?
I have a list of inputs and need to be able to fill empty cells with samples
from that list in a random fashion without replacement. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a random sample from a list?
With your data list in Y1 to Y25,
Enter in Z1: =RAND() And copy down to Z25. Then try this formula anywhe =INDEX($Y$1:$Y$25,RANK(Z1,$Z$1:$Z$25)) And copy down 25 rows ... OR less if need be. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "swrath" wrote in message ... I have a list of inputs and need to be able to fill empty cells with samples from that list in a random fashion without replacement. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create list on another tab by selecting qty from big list? | Excel Worksheet Functions | |||
How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
How to create a Sub validation list in excel? | Excel Discussion (Misc queries) | |||
Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
how do i create a list from a cell? | New Users to Excel |