I have given below a trial balance which is exported from Accounting package to excel. Negative Values are shown as CR and Postive Values are shown as DR. These values are formatted using custom format
0.00" Cr"
0.00" Dr"
I want to filter the positive values in one coulmn and negative values in another column which i am not able to do so using if command of excel. Can anybody help in filtering these values
Thanks
Murugavel