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.

  • 1
    I 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

Not the answer you're looking for? Browse other questions tagged or ask your own question.