OFFSET- Allow Insert Rows Example

Please purchase the course before starting the lesson.

Exercise 3

The problem with linking cells to each other (e.g. cell B13 is linked to D12) is that when you insert a row, the link follows the cell. In this case we don’t want that. We always want the cell to look at the row immediately above it.

In G12 to G14 use an OFFSET so these cells will always look at the row aboves closing balance, even if rows are inserted.

To see the full course contents click here.

Back to: Advanced Excel Course > Key Lookup Functions