=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