Hi - Could you please suggest a way to get this output using SORT?
CR stands for credit
DR stands for debit
If a name has only one CR or one DR they should be left undisturbed and displayed as net amount.
Sample:-
=======
Name code amt
=============
AAA CR 110
AAA DR - 50
BBB CR 200
BBB DR -150
CCC CR 85
DDD DR - 50
Name netamt
==============
AAA 60
BBB 50
CCC 85
DDD -50
Regards,
David