![]() If that was the case, the racing business would be shut down overnight (too predictable), hence using a random weighted approach)Įxcel have a Random Number Generation Add In that does this already. ( You might think why not pick the #1 rank selection as it has the most probability. The idea of the RAND is to pick one of those rank#? but with a bias towards the ranks with more probability. In my example Rank#1 has a 25% chance of winning, rank#2 a 22% chance and so on down the list. However these Rank numbers represent the order as defined by the probability that they might come fIrst in a race. If we had 7 numbers and they all had an equal chance of being the first number drawn out of a barrel then RAND would be easy. But wait, you say it's weighting the wrong way, so how about The only problem being that now that IP is in descending order, so the last argument for the Match function should be -1 (but then to prevent #N/A!s appearing the list should include a 0. Now you should be able to use those in your formula eg. [Afterthought: if you're never going to use the Prices named range then you can directly define IP as: =OFFSET(Sheet1!$B$2,0,0,COUNT(Sheet1!$B$2:$B$21))Īnd one called IP which is an offset of the above one and refers to: ![]() ![]() If so then you don't have to worry about making that column A range dynamic. Thoughts only, since I'm not 100% sure on what you're looking for…
0 Comments
Leave a Reply. |