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:
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!
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!