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.
-
1I don't think there is a builtin that would handle that, but a macro could certainly be made to work that out. – Drav Sloan Aug 10 '13 at 0:10
-
See this SU post. – chuff Aug 10 '13 at 0:36
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
