Zeroing out Positive and Negative Values in Rows

I have a spreadsheet (70,000+ rows) that contains transactions inclusive of reversals of some transactions. There is also information including date of service, product name, etc. Is there an efficient way to remove transactions and matching reversals without having to performing the task manually?

Thank you.

You would want a vba code to run through and look for matches, and then hide/delete those rows. Are these transactions labeled the same in some way, either by a transaction number or customer code? If so, that could be what you have the vba search for. Also, if it was the case that the transaction and it's reversal are both #345678 for example, you could find a vba that will just delete duplicates.

Thank you very much for the quick response.