Hi..very basic but I think my brain has done a runner.
If I have a basic list spread sheet showing various transaction columns A=date, B=description, C=income, D=expense and E=current balance, that is previous line total+income-expense, how do I get a fixed cell eg $z$100 equal to the latest line E cell
Assuming your income (col C) is shown positive and expenditure (col D) is also shown positive and the range of rows - not necessarily filled - runs from 5 to 101 then for cell Z100 the formula would be:
Alternatively if the expenditure(col D)is shown negative then the formula in Z100 would be:
This thread is now locked and can not be replied to.