combining numbers

[msnews.microsoft.com]

I have a list of over 100 different amounts. I need to identify the amounts
that add up to a specific total when they are not sequential in order in the
list. Can I do this?

 

[Niek Otten]

If you do a Google Group search
(http://groups.google.com/advanced_group_search) with this:

add up amount group:*Excel* author:grove

You get access to a comprehensive discussion about this subject. And to
solutions which range from using standard Excel functionality (Solver) to
very sophisticated software.

 

[msnews.microsoft.com]

I found the answer using a Solver process found on this site. Thank you so
much for your assistance. It saved me two days work at least.

 

[msnews.microsoft.com]

The actual address I found the Solver solution is:

http://groups.google.com/group/microsoft.public.excel/browse_frm/thread/1cbf157bd1c80aa

My thanks again to Niek Otten and to Peo Sjoblom who proposed the solution.

Peo Sjoblom

 

[bplumhoff]

Hello,

Yes, look here: http://michael-schwimmer.de/vba096.htm

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

HTH,
Bernd