VBA in excel

[murugavelmsc]

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

[xyxex]

In the column that holds the amounts use the auto filter "custom" option.

select "Contains" in 1st box & DR or CR in second.

otherwise using the IF statement

for +ve values if(right(a1,2)= "DR", A1,0) for your debit column
and
for -ve values if(right(a1,2)= "CR", A1,0) for your credit column

A1 refers to the column that holds the mixed data.

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

[Dököll]

Please carry on, I did not realize the answer added:-)

In the column that holds the amounts use the auto filter "custom" option.

select "Contains" in 1st box & DR or CR in second.

otherwise using the IF statement

for +ve values if(right(a1,2)= "DR", A1,0) for your debit column
and
for -ve values if(right(a1,2)= "CR", A1,0) for your credit column

A1 refers to the column that holds the mixed data.