Arranging a bank statement exported to excel

New Contributor

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

2 Replies



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

debit credit.JPG 

Thank you, i'll give it a go soon