ExcelBanter - Last data in colum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Last data in colum (https://www.excelbanter.com/excel-worksheet-functions/183320-last-data-colum.html)

Neorig

Last data in colum

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[_2_]

Last data in colum

=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

Gaurav[_2_]

Last data in colum

oh...if its just 10 rows long then

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

"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

T. Valko

Last data in colum

Try this:

=LOOKUP(1E100,A:A)

Will return the last numeric value from column A.

--
Biff
Microsoft Excel MVP

"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

All times are GMT +1. The time now is 04:35 AM.