Thread: What combination of numbers in a series sums to a specific value?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default What combination of numbers in a series sums to a specific value?
Check out this Tom Ogilvy classic for a way using Solver:
http://tinyurl.com/5kx9bw

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Ashley" wrote:
How do I find what combination of numbers in a series sums to a specific
value? I have the end sums and a list of values, some of which may be used
and some of which may not, and I need a way to add the values in whatever
combinations to equal all the sums.
Reply With QuoteReply With Quote