i-nth logo
Create a running balance in Excel that allows you to insert, delete, and move rows
26 April 2018

Calculating a running balance is a common and important spreadsheet task.

But inserting rows, deleting rows, and moving rows via cut and paste can introduce hard-to-detect errors in a running balance formula.

This article explains the problems with the basic running balance formula and provides two robust solutions.

Full article: Create a running balance in Excel that allows you to insert, delete, and move rows

Consulting

We can help you make better spreadsheets:

  • Reviewing your spreadsheets for errors.
  • Advice about improving your spreadsheets.
  • Training in spreadsheet good practice.

Contact us