Hi,

I am doing inter-company reconciliation and the report i have is a combination report giving breaks between two companies see following

Comp counter party Amount
C-A536 C-H145 197,789.09
C-H145 C-A536 197,789.09
C-A536 C-H145 -197,789.09
C-H145 C-A536 -197,789.09


What i want to do is eliminate duplicate as you will see C-A536 and C-H145 has break of 198K but it is giving another break of 198K for inverse combination.
is there any way i can eliminate the duplicate from the list i have 1000 of such combinations, i tried to do some unique string to eliminate them bud didnt work, so if you can suggest any function/macro to do it would be highly appreciated.

Thanks
Sanjay