This is kind of a weird request but I cannot really think through how to use excel formulas like round to solve it. Attached is a workbook as an example.

So the percentages and players will vary all the time but those are just an example. What I want to do is select a round number of 10 players based on those percentages every time. Players can be selected twice or three times. So for example, based on the given percentages, Roy Hibbert should be selected twice since he has about 20% selection and Brandan Wright 0 times since he has a near 0% selection.

Players can't be selected partially. So you cannot select a player 2.236 times like the percentage suggests.

I've tried converting the percentages to whole numbers, but if I use round, sometimes only a total of 9 players will be selected or 11 players selected.

So is there anyway to use those percentages to select a round number of 10 every time?

Test.xlsx