Welcome to the board.
One way:
Row\Col A B C D E 1 Horse Prob Cumu 2Alan 12% 0%C2: =SUM(B$1:B1) 3Barb 14% 12% 4Cain 5% 26% 5Dana 19% 31% 6Eric 9% 50% 7Fran 22% 59% 8Gary 14% 81% 9Hana 5% 95% 10 11Gary A11: =INDEX(A2:A9, MATCH(RAND(), C2:C9))
Bookmarks