Number Matching

[Guest]

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

 

[bplumhoff]

Hello Colin,

MrExcel had a contest in 2002. Michael Schwimmer beautified that
solution:
http://michael-schwimmer.de/vba096.htm

Please notice that this program stops when a solution is found. It does
not give you all possible solutions.

HTH,
Bernd

 

[Guest]

Hi Bernd,

Many thanks

Just the Ticket

Regards

Colin