I am attempting to write a formula in excel 2003. What I am trying to
accomplish is to enter a list of values, say 20, 15, 4, 2.5, 1, 3, 6, 8.878,
17, 20.75, 6.25. Of these values, I want to be able to use the numbers that
get as close to a total of 40 as possible, without going over. The remaining
numbers would be used with an additional set of numbers to achieve the same
goal of getting as close to 40 as possible without going over. This would
continue until the last set of numbers would be used. Any ideas to get
started??

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1