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
Please I need some "Formula or VBA" solution for my this problem
Thank you in advance
Regards,
Kishan
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