Filter dr and cr balance

Originally Posted by :) Sixthsense :)

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Function GetType(r As Range) As String
    GetType = Right(r.Cells(1).Text, 2)
End Function

In C2 Cell

=GetType(B2)

Drag it down...

thanks and also an help to minus (-) sign before all Cr Balance if that possible

Sandy

Originally Posted by :) Sixthsense :)

In C2 Cell

=IF(GetType(B2)="DR",B2,0-B2)

Drag it down...

Or

=IF(GetType(B2)="DR","DR","-CR")

Thanks sir....

Sandy