combining numbers

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?

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.

--
Kind regards,

Niek Otten


"msnews.microsoft.com" <tom@jerry.com> wrote in message
news:%23BWX0YMAGHA.984@tk2msftngp13.phx.gbl...
>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?
>

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.

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:elzWCkMAGHA.740@TK2MSFTNGP12.phx.gbl...
> 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.
>
> --
> Kind regards,
>
> Niek Otten
>
>
> "msnews.microsoft.com" <tom@jerry.com> wrote in message
> news:%23BWX0YMAGHA.984@tk2msftngp13.phx.gbl...
>>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?
>>
>
>

The actual address I found the Solver solution is:

http://groups.google.com/group/micro...cbf157bd1c80aa

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

Peo Sjoblom
"msnews.microsoft.com" <tom@jerry.com> wrote in message
news:%23BWX0YMAGHA.984@tk2msftngp13.phx.gbl...
>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?
>

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