Excel 2007 : RANDOM dice NOT FAIR

hello all
plz hlp:
I have a dice /coin problem.
the general problem is like this how to make a not fair dice/coin?
in particular I have , let say a dice , with 22 faces .
I want to get more often some of the faces then the others, even more I want that some faces to be obtained with some particular incidence. In example lets say the face F11 should appear 20 times if I roll the dice 100 times(20%) so if I throw the dice 400 times ... I should get similar results (20% +/- a percent) ... and so one for all the faces.
the input data looks like this:

Please Login or Register  to view this content.

The output data should be a in a cell, so if I fill down a series - I ll get the expected values.
I have tried these: =INDEX($A$2:$A$23,RANDBETWEEN(1,COUNTA($A$2:$A$23)),1)
.. but do not know how to "manipulate" the output, to take in the second column...
thx u all for u time,
Vali.
here I edited:
to be more specific I ll try to add some details about the expected output.
so the output should look this

Please Login or Register  to view this content.

so if I do a a check like "=count if (C:C400,"F5") /400" I ll get a % very close to that I had inputed as incidence initially..
hlp

Welcome to the forum.

Maybe like this:

Please Login or Register  to view this content.

Originally Posted by shg

Welcome to the forum.

I must star with ty for u kind welcome!
I had edited the post to make it more clear ... and now I m struggling to understand if u formula fits my requirements.

Originally Posted by shg

Welcome to the forum.

Maybe like this:

Please Login or Register  to view this content.

unfortunately the solutions doesn't fit:
there are two major problems:
1 all faces should appear at least once after 100-300 rollings- some times output is 0
2 it's not constrained enough by the "cumu" column. the tollerance should be around 0.5%-0.8%. the constrictions should be more evident ... coes I need to add more conditions (age and 2 oters paramters if u could spent u time I can uppload or msg the file with the particular problem).
PLZ HLP!!!!!

1 all faces should appear at least once after 100-300 rollings- some times output is 0
2 it's not constrained enough by the "cumu" column. the tollerance should be around 0.5%-0.8%.

Sorry, that's not how random deviates work. If you toss a fair coin, the outcome of the next toss doesn't change regardless of what you flipped in prior tosses.

That said, it's wildly improbable that for the example shown that every number wouldn't appear in 300 rolls.

EDIT: The formula in D3 and down in your spreadsheet is wrong. It should be =SUM(C$2:C2)

Here's the first result I got for 10,000 trials:

Please Login or Register  to view this content.

ty v much.. there are no words to express my gratitude -because after correcting the formula the results improved dramatically.
have I understand well...? my limited numbers of trials(350-400) is the major impediment to obtain the desired vallues?
so neither in my dreams or in reality does not exist any method to add a factor to final formula so the results fit in?
ty again for u time >:D<

so neither in my dreams or in reality does not exist any method ...

Stop and think about it: If not rolling some number after some number of rolls meant it were more likely to come soon, then the rolls would be predictable, which is the opposite of random, right?

See http://en.wikipedia.org/wiki/Memorylessness