Go to Google newsgroup search and search for
combination equal number
in groups microsoft.public.excel.*
You'll find lots of hits on how to do this with Solver.
On Sat, 5 Mar 2005 19:17:01 -0800, Pax wrote:
Which function tells me which numbers in a column equal a certain number?
For example:
25,000
100,000
2,000
19,000
Which of these numbers, added together, will give me the result of $121,000?
|