Finding combinations that add up to X
 

Hello,
If I have a long list of numbers (both + and -) on a spreadsheet, is
there a way of finding possible combinations of two or more of these
numbers that add to to a certain figure?

Thanks v much,
Matthew


--
mj6987
------------------------------------------------------------------------
mj6987's Profile: http://www.excelforum.com/member.php...fo&userid=3526
View this thread: http://www.excelforum.com/showthread...hreadid=530831

Finding combinations that add up to X
 

See this post by Niek Otten a couple of days ago http://tinyurl.com/mngpm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mj6987" wrote in
message ...

Hello,
If I have a long list of numbers (both + and -) on a spreadsheet, is
there a way of finding possible combinations of two or more of these
numbers that add to to a certain figure?

Thanks v much,
Matthew


--
mj6987
------------------------------------------------------------------------
mj6987's Profile:
http://www.excelforum.com/member.php...fo&userid=3526
View this thread: http://www.excelforum.com/showthread...hreadid=530831

Finding combinations that add up to X
 

Hello,

I suggest to look he http://michael-schwimmer.de/vba096.htm

It is a nice beautification of Mr. Excel's winning solution of his
challenge of the month (August 2002): http://www.mrexcel.com/pc09.shtml


And it seems to be quicker than the other solution (I tested with
Michael's example).

HTH,
Bernd

Finding combinations that add up to X
 

That's because Harlan's solution is more generic than that, it finds all
combinations that will satisfy the sum, not just one.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
Hello,

I suggest to look he http://michael-schwimmer.de/vba096.htm

It is a nice beautification of Mr. Excel's winning solution of his
challenge of the month (August 2002): http://www.mrexcel.com/pc09.shtml


And it seems to be quicker than the other solution (I tested with
Michael's example).

HTH,
Bernd