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,