last value in a column

C

chaz

I have a checkbook ledger in an excel file. As the number
of records in the sheet has grown, I have to scroll down
to the end of the ledger to find the current balance. Is
there a way to "dynamically" find the last value in a
column of data, keeping in mind that the row location of
the last value will change over time?
 
A

Andy B

Hi

Do you want to go to the cell or just view its contents?
To go to the cell click on a single cell inthe column and then double-click
its bottom border. This will take you to the last cell in the column.
To see what is in the last cell in the column use something like:
=INDEX(G:G,COUNTIF(G:G,"<>"),1)
 
A

Aladin Akyurek

=LOOKUP(9.99999999999999E+307,A:A)

would return the last numerical value from column A.
 
Top