Matching uneven negative and positive values in column that sums up to zero

[Charlicito]

Hi !

This is my first question here in this Forum, so if there is already an answer, please let me know.

I have a problem i cant solve. I need to match uneven positive and negative numbers in a column that sums up to 0. The most tricky part here is that if a certain negative number is very big it need more than one positive value to reach zero, and the sum wont be exact. See below for example, and below that the result i want to acquire:

Firm	Value
1	-48
2	-1160
3	853
4	-298
5	-1521
6	721
7	-9517
8	-1269
9	-944
10	-3946
11	-10153
12	17635
13	5485
14	4664
15	-501

<colgroup><col><col></colgroup><tbody>
</tbody>

I need the "best fit" of matching for example (if true): Firm 11 matched with Firm 13&14, Firm 5 with 3&6... and so forth until all firms are taken into account.

How do I do this?

 

[VoG]

This may help you Combination of numbers that sum or match a target value

 

[Charlicito]

Thanks! I will look into it but VBA of this length is not my biggest strength....