Return Last Value in Column

[maxhugen]

In a column I have a "balance" (as in a bank account).

I'd like to get the value of the last cell which is not empty in thi
column, which in this case is the "current balance", to use elsewhere.

Can anyone suggest how to do this please?

MTIA,

Max Hugen
Sydney, Australi

 

[Frank Kabel]

Hi
try
=VLOOKUP(9.9999999E307,A1:A10000,1)
to get the last value from column A. Assumption: It's a number (not a
text value)

 

[Dave R.]

Here is one method, but I bet theres a simpler one out there...

=INDIRECT("e"&MAX(IF(E19:E30<>"",ROW(E19:E30))))

"e" is the column containing your values; e19:e30 is the range where your
values can be (make it bigger than the actual range of numbers of course) --
and the formula must be entered with CTRL SHIFT ENTER, it will look like
this when entered properly:

{=INDIRECT("e"&MAX(IF(E19:E30<>"",ROW(E19:E30))))}

 

[just_jon]

Assuming column C holds the numbers of interest, then --

=INDEX(C:C,MATCH(9.99999999999999E+307,C:C),0)

should return the bottom-most numeric value

 

[maxhugen]

Many thanks Frank

That's just what I needed!

Thanks also to Dave and just_jon ! Which goes to show - there's mor
than one way past a wall !


Cheers, Max
Sydne