matching a combination of numbers

Does anyone have a formula to find out which combination of a group of
numbers matches a total ? (when we receive a payment from a customer with say
20 outstanding amounts it would be really nice to get a spreadsheet to say "i
think these are the ones being paid because they add up to the total figure
that is on the cheque)
Thanks Mike

I had a similar problem, If I could list the various combinations, I could
match the solution. See:

http://groups.google.com/group/micro...1f529de2aaf685
--
Gary's Student


"mike" wrote:

> Does anyone have a formula to find out which combination of a group of
> numbers matches a total ? (when we receive a payment from a customer with say
> 20 outstanding amounts it would be really nice to get a spreadsheet to say "i
> think these are the ones being paid because they add up to the total figure
> that is on the cheque)
> Thanks Mike

thankyou it seems its going to be too complicated for me - I can't understand
the code but thanks anyway
Miek

"Gary''s Student" wrote:

> I had a similar problem, If I could list the various combinations, I could
> match the solution. See:
>
> http://groups.google.com/group/micro...1f529de2aaf685
> --
> Gary's Student
>
>
> "mike" wrote:
>
> > Does anyone have a formula to find out which combination of a group of
> > numbers matches a total ? (when we receive a payment from a customer with say
> > 20 outstanding amounts it would be really nice to get a spreadsheet to say "i
> > think these are the ones being paid because they add up to the total figure
> > that is on the cheque)
> > Thanks Mike