What I would like to do is develop a code/macro that will sort rows that contain offsetting dollar amounts based on their account numbers. Each account number may have several entries, but they offset between negative and positive dollar amounts. I would like to be able to sort those rows by Column A (Account number), then have offsetting amounts in rows next to each other so they can easily be deleted from the excel sheet. Example:
Loan # Date of Pmt Principal Interest Total Payment Tran Code Type
****128 07/16/14 (557.57) (1,372.37) ($1,929.94) 999 Past Due
****128 07/24/14 557.57 1,372.37 $1,929.94 914 Prepaid

I have over 10,000 rows of information like this. I would like to get it so that if the loan numbers for entries have total payments that offet each other, or even have differences, to sort them in a way that they can be either deleted if they match or listed next to each other with the differences in amounts shown.