Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random within range
Hi,
Just wondering can Excel do the following:- A large worksheet consists of employees with the decade they joined. employee decade 1 80 2 90 3 70 etc. The request is to produce a random sampling but taking into account the percentage of employees who joined in a particular decade. So for example (simplified) Decade Percentage 70's 10% 80's 30% 90's 45% 00 15% In other words if 1000 employees are extracted from the main worksheet, 100 of them should be randomly chosen from the 70's and 150 should be from the 00's. I can divide the worksheet per decade and produce a random sample, but wonder is there a means of doing this with one sheet. All help gratefully received, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) |