new column to confirm offsetting transactions

[Carlyn]

Hi

I am looking for the best tool that will identify where there are offsetting transactions in a list of data. I have attached a sample to demonstrate. 

I need 2 outputs, 1 set that shows the items that zero off on amount but have matching SIS_Account and matching description. 

1 output that provides those offsetting rows and 1 output that doesn't, but both still holidng the same columns as the input.

I have tried summarise, filter, Unique, but they are not giving me what I need. 

Can anyone suggest the best way to do this?

[binuacs · Accepted solution]

@Carlyn one way of doing this

[Carlyn]

Thank you!