asked on

MS Excel - Cells to Find Summary

I am looking for an Excel function that identifies any combination of cells in a colum which when summarized will equate to a given number. For example in the attached spreadsheet, the given is 177.41. I need to find what combination of numbers equate to that. The simple answer is 29.26 plus 148.15 (highlighted yellow in the attached). But it could be a longer list and it could be a different combination of summarized numbers - not just two.

Is there such a function?
2014-300.216505-GL-SAMPLE.xlsx

SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CFMI

ASKER

"You can reduce that number by sorting them in order, and then pruning the tree when you get over the amount." You're suggesting that the tree gets pruned by small to large. Of course that's not always the case so besides the fact that your "2 to the power of 141" answer suggests we're looking for two numbers, I see how no combination that big is really possible. I'll chew on this and either close if we're done looking or respond differently if we can tweak / simplify the question. Thank you.

ASKER CERTIFIED SOLUTION