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


"Neorig" wrote in message
...
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