Find all possible combinations of sums

[Gav13]

Hi all,

Long shot but I was wondering if there was a way of showing all the possible combinations that equal the sum of opposite values in a table.

Here is the example:

Ref 1	-50
Ref 2	25
Ref 3	25
Ref 4	-10,000
Ref 5	5000
Ref 6	5000

So in this case its quite simple, the possible combinations are Ref 1 = Ref 2 + Ref 3 and Ref 4 = Ref 5 + Ref 6

However, I'm working with a total of over 15,000 lines with multiple combinations and complex sums - so not sure where to even begin with this! Of course, some might not even equal at all.

It may be easier to split out the negative and the positive values into two tables, so I am looking for the possible combination in on table for -X in the other.

Any help is greatly appreciated!

 

[BSALV]

However, I'm working with a total of over 15,000 lines with multiple combinations and complex sums - so not sure where to even begin with this! Of course, some might not even equal at all.

i suppose this is a kind of "checking what parts of an invoice is paid" and with 15.000 lines, this is an impossible question.
You have to reduce those 15.000 to say max. 10 lines per question and even then it's tricky.
If you can't reduce to that figure, it's hopeless ... .