CODEWITHSUNDEEP
excelexcel-formula
Prem
Prem

Reputation: 31

Formula to return the latest running balance

I have a sheet that consists of three columns. they are

enter image description here

"IN" | "OUT" | "BALANCE"

IN - when i enter a numeric value in a row on this column, the "BALANCE" (which is actually a running balance) would get incremented by whatever the value entered under this column.

OUT - the same as IN except it decrements and updates the "BALANCE" Running Balance

What i am trying to figure out is:

I have a separate summary sheet which is supposed to show the latest running balance (only) as per the updated figures

The problems i have are: 1: how to retrieve the latest running balance?

2: The rows may extend as and when updated, it might grow from a single entry to 100's of entries (rows), in such a scenario how do i get the last updated running balance?

Upvotes: 1

Views: 422

Answers (2)

Gary's Student
Gary's Student

Reputation: 96773

To get the bottom value in column C of Sheet1 use:

=LOOKUP(99^99,Sheet1!C:C)

Upvotes: 1

Chrismas007
Chrismas007

Reputation: 6105

First Response on Google for "Formula to Return the Last Value in Column":

Assuming no blanks in column C:

=INDEX(C:C, COUNTA(C:C), 1)

Upvotes: 1

Related Questions