Welcome to the forum
I have made a guess as to what you want and how you want it laid out. If I'm close then great, if not then it would help if you upload a workbook showing how you see this working along with your manually calculated expected results.
That said, here's my attempt:
FirstComeFirstServe.png
G2:H4 lists each of the areas and their capacity. I have made this a named range "areaList"
Col-E is the calculated assigned area for each applicant. In E2 and copied down:
I have attached a workbook implementing the above.
Let me know whether this is heading along the right path.
Bookmarks