Doing an allocation in Excel

I have task in excel that I must perform that I hope you'll will be able to help me with.

I am allocating limited money and I need to allocate the same to everyone in increments until the pool is exhausted.

So its almost like dealing cards. For each round I would deal everyone 5 cards until the deck is exhausted.

However, there would be people around the table who have requested more cards than others.

At the point in a round where there are more people awaiting cards than cards available in multiples of fives (Three people remaining and only 12 cards), I must run these scenarios.

1. The person who has the least amount outstanding would be issued first
2. The person with the most outstanding would be issued first
3. It would be shared equally

Adding cross post link

mrexcel.com/forum/excel-questions/1093241-doing-allocation-excel.html

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

No. Type out the location of your other posts. Read the link I gave you in RED to understand this whole crossposting. It is something you will run into on every excel forum.