How to find a needle in a haystack?

Here's my situation. I am an accountant. It is common for me to have a
column of numbers (typically amounts including dollars and cents). These
numbers might be a listing of expenses in an account so they are more or less
random. Frequently, I want to know whether adding two or more of these
numbers in this column will add up to a given amount. Is there an easy way
to get excel to determine whether adding some combination of one or more
numbers in a list will add up to some given amount?

Thanks in advance for any help you may give.

"ScottJSP" <ScottJSP@discussions.microsoft.com> wrote in message
news:F935F8DE-23D9-45FF-B4B2-5AEA7682106A@microsoft.com...
>
>> Here's my situation. I am an accountant. It is common for me to
>> have a column of numbers (typically amounts including dollars and
>> cents). These numbers might be a listing of expenses in an account
>> so they are more or less random. Frequently, I want to know
whether
>> adding two or more of these numbers in this column will add up to a
>> given amount. Is there an easy way to get excel to determine
>> whether adding some combination of one or more numbers in a list
>> will add up to some given amount?
>>
>> Thanks in advance for any help you may give.
>>
>>

See here:


http://groups-beta.google.com/group/...cbf157bd1c80aa

Hi!
There's a nice short VBA routine at this address:

http://groups-beta.google.com/group/...f2aa63258093c7

I also came upon a (much longer) generalised routine a little while ago and, while I have a copy of it, I can't remember where I got it from. It was possibly the winner of a competition to do just "that" and it might have been associated with Mr Excel. Can anyone add to that?

Alf