Random sample with proportions

[Guest]

I want to create a random sample for employee focus groups. In the final sample, I want to have a representative number of gender, city/state, job level and ethnicity (all fields in the spreadsheet). So for example if there are 50% males and 50% females, I want 50% males and 50% females in the final random sample. If the process involves a macro or VBA, I would appreciate it if you would let me know how to insert it into a file then run it

Thanks.

 

[Max]

Please do not multi-post

See replies to your post in:
microsoft.public.excel.worksheet.functions

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----

I want to create a random sample for employee focus

groups. In the final sample, I want to have a
representative number of gender, city/state, job level and
ethnicity (all fields in the spreadsheet). So for example
if there are 50% males and 50% females, I want 50% males
and 50% females in the final random sample. If the
process involves a macro or VBA, I would appreciate it if
you would let me know how to insert it into a file then
run it.