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
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
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
Hello,
I suggest to look here: 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
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)
<[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I suggest to look here: 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
>
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)
<[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I suggest to look here: 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks