ExcelBanter - Last number in Column

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

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

- - Last number in Column (https://www.excelbanter.com/excel-worksheet-functions/86623-last-number-column.html)

Two-Canucks

Last number in Column

In a spreadsheet Column H is filled randomly
with numbers and blanks from Row 13 down.
I want to find the LAST number i.e. occurring in
the highest row number in the Column.
Preferably found by worksheet formula, failing that
I could use a macro.
Many thanks for any solutions.

--
Occasionally stumped

Peo Sjoblom

Last number in Column

=LOOKUP(9.99999999E+307,H:H)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

"Two-Canucks" wrote in message
...
In a spreadsheet Column H is filled randomly
with numbers and blanks from Row 13 down.
I want to find the LAST number i.e. occurring in
the highest row number in the Column.
Preferably found by worksheet formula, failing that
I could use a macro.
Many thanks for any solutions.

--
Occasionally stumped

All times are GMT +1. The time now is 02:22 AM.