how to pick a random entry in excel based on percent

im trying to find some way to pick a random entry from a list based on percent. id like to do this in excel but im not sure how to do it. heres an example of the list:

A - 25% | B - 50% | C - 25%

id like to be able to randomly select one of the variables based on there corresponding percent (B is chosen 50%, C is chosen 25% etc..) how would i do this? (the real list has about 250 variables, not sure if that changes anything)

https://stackoverflow.com/questions/66523981/how-to-pick-a-random-entry-in-excel-based-on-percent March 08, 2021 at 11:32AM