Lets say I have 20 cells. I want to randomly assign a label to the each cell from 5 choices, like "Blue", "Orange", "White", "Green", and "Black". But I want to assign a probability of selecting the
labels. So the percent probability of choosing Blue would be 56% and White would be 23%, etc. . .
is there a function that allows me to do this?
Blue C2: =SUM(B1:C1) Orange White Green Black Black A8: =INDEX($A$2:$A$6, MATCH(RAND(), $C$2:$C$6))
Entia non sunt multiplicanda sine necessitate
Could you explain what you did? I don't understand the functions and the setup of the table.
Column A lists the colors and B their probabilities.
Column C creates a lookup table as the cumulative probabilities of selecting colors.
The formula in A8 calculates a random color by matching a random number into the lookup table.
Awesome. Thanks.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks