How do I filter for data that have values that cancel each other out grouped by the Account number?
For example, the first two rows meet the criteria because they both belong to the same account, have the same values in Debit (Positive) and Credit (Negative) which equals to zero. Whereas the third row doesn't meet the criteria because there isn't a 200 credit amount in Account 1 to cancel it out. Thanks in advance!
Original:
| Account | Debit | Credit | Net Amount (Debit - Credit) |
| 1 | 100 | | 100 |
| 1 | | 100 | -100 |
| 1 | 200 | | 200 |
| 2 | | 200 | -200 |
| 2 | | 300 | -300 |
| 3 | 300 | | 300 |
| 3 | | 300 | 300 |
Desired result:
| Account | Debit | Credit | Net Amount (Debit - Credit) |
| 1 | 100 | | 100 |
| 1 | | 100 | -100 |
| 3 | 300 | | 300 |
| 3 | | 300 | -300 |
