Hello,
I explain my problem:
I have multiples events, each one with a occurence probability (ex;
event A: 20%, event B: 40%, event C: 10%, event D: 30%)
I need to create a list of values with my events, respecting the
probabilities (ex: creating a list of 100 values, in a aleatory order;
with 20 A, 40 B, 10 C and 30D)

The thing is that it has to be random, and for a veeery big list (about
9000 entries)

Is there a simple way to do it with excel macros, or should I try it
another way?

Thanks a lot


--
MrKermit
------------------------------------------------------------------------
MrKermit's Profile: http://www.excelforum.com/member.php...o&userid=33021
View this thread: http://www.excelforum.com/showthread...hreadid=528467