I have data per date (see example attached for 1 date). Work sheet with both incoming and outgoing.
Each work-sheet in the file are sorted in order of booked transaction.
I want to calculate the netted amount per transaction in row order (Incoming = credit, outgoing = debit).
By sorting the data per row number I could get a curve of aggregated net-amount on the account (per transaction).
How should I do?