Hello,
Any help on this will be appreciated. I have the below table that has a duplication number with the corresponding amount.
I want to remove duplicates with their corresponding amounts that sum up to 0. As an example.
92111110039625 as -2699, -2699, and 2699
Also 92111110039625 as -165, -165, and 165
-2699 and 2699 should cancel out because it's = 0
same for -165 and 165 should cancel
what I should be left with on 92111110039625 should be -2699 and -165 in the new table. The same goes for the rest of the number.
not all numbers are duplicate and not all number have negative amounts.
Thank
| Number | Amount |
| 921111110039625 | -2699 |
| 921111110039625 | -2699 |
| 921111110039625 | -165 |
| 921111110039625 | -165 |
| 921111110039625 | 165 |
| 921111110039625 | 2699 |
| 921111110268668 | 600 |
| 921111110268668 | 7,921.01 |
| 921111110268668 | -7,921.01 |
| 921111110268668 | -600 |
| 921111110268661 | -1,850.00 |
| 921111110268661 | -40 |
| 921111110268658 | -2,422.80 |
| 921111110268386 | -8,562.50 |
| 921111110268386 | -8,562.50 |
| 921111110268386 | -120 |
| 921111110268380 | 135,823.17 |
| 921111110268380 | -135,823.17 |
| 921111110268373 | -1,357.50 |
| 921111110268373 | -1,357.50 |
| 921111110268373 | -85 |
| 921111110268368 | -3,000.00 |
| 921111110268368 | -85 |
