Last data in colum

[Neorig]

Can anyone help with this one, if i have a colum which is ten rows long and
on every hour i fill in a quantity. what formula can i get to say what the
last figure i filled in

 

[Gaurav]

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

 

[Gaurav]

oh...if its just 10 rows long then

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

 

[T. Valko]

Try this:

=LOOKUP(1E100,A:A)

Will return the last numeric value from column A.