Formula Assistance Required

[mfolland]

Hi There

We receive payments that offset each other. It would be a dream if we could easily identify these payments with a formula. For example we receive a $100 payment, and on a separate line we receive a -($100) claw back. Both payments can be identified by the same phone number and that they offset each other. I need a formula that can find phones numbers with the opposite dollar value. It is much easier to reconcile the rest of the payments with these in/out payments removed.

9054677889 $100
9054677889 -$100

Thank you, Mike