abc weighted random

[Kishan]

Using Excel 2000

Hi,

I want a "1" random cell to be filled en the each row C6:E12 imagine there are 7
Lottery winning drum...

In the first Lottery winning drum there are 48 balls with letter a, 31 balls with letter b, 21 balls with letter c total 100 in the C6:E6.
So it is possible the random take in account the weight of filled balls a, b, c and fill the cell accordingly or it has to be normal random selections

And in the rest Lottery winning drum C7:E12 will be applied the same method.

So far 7 random selected cells will be highlighted in the range C6:E12

Balls With	Balls With	Balls With
Letter a	Letter b	Letter c
48	31	21
71	18	11
40	30	30
56	26	18
74	16	10
27	34	39
34	33	33

Please I need some "Formula or VBA" solution for my this problem

Thank you in advance

Regards,
Kishan

 

[Kishan]

Indeed, I have overlooked it. Sorry Kishan.

J.Ty., your CF idea worked indeed thank you for your kind help

Kind Regards,
kishan