Related Posts
Senior service desk analyst
Cause of death - Waiting for the response from HR

Additional Posts in Accounting
What the firms opinion on holding crypto?
Raise your hand if you just cannot do it today.
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.






I used to have a spreadsheet for this. It would use the solver tool in Excel to iterate through a list of numbers until it found a sum that worked. I haven’t thought about it in 10+ years and can’t seem to find the instructions, but using solver might send you down the right path.
EDIT: I think this will get you there. https://www.ablebits.com/office-addins-blog/find-combinations-that-equal-given-sum-excel/
Said another way, there may be 15 different number values that together equal bucket 1, however, I am missing the identifying attribute to easily identity each of those 15 numbers without guessing. Is there any methods to easily figure this out without guessing?
YouTube has great examples of that
There is also an Excel Genius bowl you might post this in.
Keep in mind some of these will take sometime to run and it will lock up your excel when processing. Depending on the search you choose like binary or non binary search. But Google and YouTube is your friend like the other person said.
I’m a bit of an excel nerd, I believe there has to be a way. YouTube has many channels which teach many functions and how to’s with regards to formulas. Leila Gharani is one I would recommend. However, the solution you require may not be one formula, it may require a combination. That said, Goal Seek maybe a starting point.