Find last valid value in a column.

[filipedscorrea]

Ei, guys, what's up?

I'm trying to find a formula that returns the last valid number in a column.
What i learned so far is a formula that works only if there's no empty cell in the column.

I mean,

A1 5
A2 7
A3
A4 8
A5 4

A formula that returns "4" as answar, no "7".
Sorry for being a noob in excel. I'm just a beginner. Sorry for that bad english too. I'm brazilian.
Thanks for now.

[XOR LX]

Hi,

Is the entire column either blank or numerical?

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

Regards

[filipedscorrea]

Hi,

Is the entire column either blank or numerical?

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

Regards

Thanks for respond. But I tried and that didn't work.
I google it, and I found this:

=OFFSET(<StartCell>,MATCH(MAX(<Range>)+1,<Range>,1)-1,0)

but that also didn't work. Excel tells me that there is a error in the formula, witch i can't find.
Can you help me in that one?

[Fotis1991]

You will find anything you need here!

http://www.xldynamic.com/source/xld.LastValue.html

[XOR LX]

What's in the column? Numbers? Text? A mixture?

Regards

[Jonmo1]

If the lookup didn't work, the most likely explaination is that your numbers are not really numbers.
They are "Numbers Stored As Text"

Try this instead
=LOOKUP("z",A:A)