Formula to cancel out Credits

[Connor-7]

Hi all,

I need to match debit and credit value using a Unique ID, activity and price.
The file I use has thousands of rows, so I highlight the matching pairs and then filter off them once complete.

Is there a formula to help speed this up?
I've attached a file with a small amount of fake data as an example with what the completed outcome would be.

Any advice would be appreciated, thanks

[mehmetcik]

Are you allowed to use Macros?

I imagine a formula based solution would be very complicated.

A macro could look for all your credits and if there was a matching debit move the pair to another column or to another sheet.