Excel: Which numbers in a column equal a certain number (withou.
 

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?

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?