Forum Discussion

VSheppard's avatar
VSheppard
Copper Contributor
Nov 17, 2022

Arranging a bank statement exported to excel

Hi, I really need some help as I have no clue... I have exported a bank statement to excel and I need to seperate the debit and credit and then add them up
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 17, 2022

VSheppard 

=VSTACK(HSTACK({"debit"."credit"}),HSTACK(IF(B2:B5>0,B2:B5,""),IF(B2:B5<0,B2:B5,"")))

You can try this formula if you have access to VSTACK and HSTACK.

 

  • VSheppard's avatar
    VSheppard
    Copper Contributor
    Nov 17, 2022
    Thank you, i'll give it a go soon

Resources