Hey all,

Not sure if this can be done using functions or if it requires a macro
but here goes...

I have a long list of numbers relating to invoice totals.....I need to
know which combination of numbers would equal the total given to me for
invoices charged at a particular rate of tax.....

To provide an simplified example:

I have ten numbers referring to invoice totals: 100, 45, 2000, 50, 11,
2020, 66, 3333, 1265, 88

I know that the total for invoices charged at a rate of 21% = 5419

I want to know is there a way of creating a function (or macro) that
would identify that the combination of 2020 + 66 + 3333 would give me
the required total???

Does that make sense??If not tell me and Ill try to simplify or
elaborate as required...

I would really appreciate any help...

Thanks in advance


--
Handsy11
------------------------------------------------------------------------
Handsy11's Profile: http://www.excelforum.com/member.php...o&userid=25098
View this thread: http://www.excelforum.com/showthread...hreadid=386086