•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
Tagged with
#machine learning in spreadsheet applications
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#modern spreadsheet innovations
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#budget allocation
#applications