How to filter for rows with values that offset each other in different rows?

[overhead_press]

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

[Qiu]

@overhead_press 
How about Account #2, it has many credits, when bing filtered out?

[overhead_press]

So not for account 2 because they don’t have a debit amount in the same account to offset it. 

[overhead_press]

So not for account 2 because they don’t have a debit amount in the same account to offset it. So for example there would need to be one transaction of 200 and one for 300 in the debit column for account 2 for it to show up in the output.

[Christina_H · Accepted solution]

This should do it