In Microsoft-Excel 2007 How do if find a subset of numbers that add to a given total?

In Microsoft-Excel 2007 How do if find a subset of numbers that add to a given total?

How do I find a subset of numbers that add to a given total? For example: i have a column of numbers indicating payments received. I need to match these various numbers to a total deposit amount.

Antwort1

There is a cheap Excel add-in that finds the combinations of numbers that give a desired sum. You can find it here: SumMatch.com

verwandte Informationen