Nov 17 2022 05:15 AM
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
Nov 17 2022 05:33 AM
=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.
Nov 17 2022 05:53 AM