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
Bookmarks