Prize Distribution Pool help

[svfulk]

I am trying to come up with a formula/sheet that distributes points to different placement of partipants. So the person that comes in first gets the largest % share, 2nd gets next largest and so on depending on how many # of partipants I have. Need something where I can plug in a different # of partipants and it auto changes the % of each placement depending on how many there are. Is this possible? Thank you Excel Wizards.

[HansDouwe]

That is certainly possible, but first I would like to know how you want the percentages to be distributed.
In case of 4 participants 40% 30% 20% 10% meet your criteria. but also 53%, 27%, 13%, 7%. and so on,

[HansDouwe]

Here are 2 possibilities, but there are so many more
Possibility 1: please try in A2:

Please Login or Register  to view this content.

Possibility 2: please try in B2:

Please Login or Register  to view this content.

I would like to hear your feedback.

[svfulk]

Thanks for your reply, the first one is more along the lines of what I am looking for. I like the aspect that every place gets points but if possible how to give the 1st place a higher % and rest of the top placements? I'm not sure if this works mathematically but would like to see if it is possible

[HansDouwe]

In this case, a mathematical approach is possible, but it starts with indicating what you consider important in the distribution.
In other words, how to judge whether a given distribution is desirable or not.
Must there be a minimum percentage for the last prize (perhaps to be defined as a function of the number of prizes or number of participants), and so on and so on and so on.

It is also important to know which MS-off version you are using. (2021 or 365??). Excel 16.54 is something else.

[svfulk]

All placements should get a percentage even if it is a fraction of a percent. I am currently using Excel 16.54. Also to give you an idea on a range that would be ideal, the winner should get at least 12ish% and the winner should get no more than 25ish%. I don't anticipate on ever having more than 100 subjects or participants if that helps this case.

[svfulk]

A range between 40-60 participants seems like the average amount of participants that this will be used for.

[bsalv]

like this perhaps

[svfulk]

Wow this is perfect thank you so much for your help!

[HansDouwe]

Thank you for your answers that certainly help to find a good formula.
Good to hear that you have also received a solution that meets your requirement.
Consider adding reputation to all the helpers you think deserved.

[bsalv]

i think Hans can make my proposition more 365-proof, mine is more "old school"