Using the last number in a column

M

MarkT

Is there a way to use the last number in a column (in a formula) when you
won't know what the exact cell is where that number will be located? The
last number will not be in a constant cell, this column is a running balance
column so additonal rows will be added daily.

Thanks for your help!
 
P

Peo Sjoblom

One way

=INDEX(A1:A10000,COUNT(A1:A10000))

I am assuming here that there are no blanks, replace
A1 with the cell the holds the first number and A10000 with a large enough
number you'll know you won't go beyond

If there are blanks you can use

=LOOKUP(2,1/(A1:A10000<>""),A1:A10000)
 
M

MarkT

Thanks Peo,

That worked perfect!

Peo Sjoblom said:
One way

=INDEX(A1:A10000,COUNT(A1:A10000))

I am assuming here that there are no blanks, replace
A1 with the cell the holds the first number and A10000 with a large enough
number you'll know you won't go beyond

If there are blanks you can use

=LOOKUP(2,1/(A1:A10000<>""),A1:A10000)

--

Regards,

Peo Sjoblom
Click to expand...
 
Top