Charlicito
New Member
- Joined
- Sep 10, 2014
- Messages
- 2
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:
<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?
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?