C
colin
Hi
I would be grateful if you could advise if there is a function that can do
the following:
I have a column with a list of numbers:
a1 13
a2 16
a3 24
a4 19 etc
and I need to find which nubers add uo to a fixed number eg 35 answer is a2+a4
The need is from an accounting point of view where there is a series of
invoices outstanding with values to 2 decimal places.
I appreciate that there may be several combinations in the result but if the
assumption is made that there is only one is there a programatical way of
checking?
Kind regards
Colin
I would be grateful if you could advise if there is a function that can do
the following:
I have a column with a list of numbers:
a1 13
a2 16
a3 24
a4 19 etc
and I need to find which nubers add uo to a fixed number eg 35 answer is a2+a4
The need is from an accounting point of view where there is a series of
invoices outstanding with values to 2 decimal places.
I appreciate that there may be several combinations in the result but if the
assumption is made that there is only one is there a programatical way of
checking?
Kind regards
Colin