•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to allocate available budget to top scored applicants, until the budget runs out?
I am creating a spreadsheet of all applications received for a pool of funding (there will be up to 300 applications) and each application will be scored. I want to see how many of the top scored applications we can fund with the allocated budget. I’ve included a screenshot of a fake scenario.
What I’ve tried is:
- Sorting column B from largest to smallest
- Adding conditional formatting to C8 to turn green when under the allocated budget amount
- Adjusting the SUM of column C until C8 turns green
However, I was wondering if there was a less manual way to do this? Possibly one that doesn’t require sorting? The people who will be using the spreadsheet aren’t the most tech savvy so I’m trying to make it as easy for them as possible.
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site