To return the last numerical value, try...

=LOOKUP(9.99999999999999E+307,A2:A100)

Adjust the range accordingly.

Hope this helps!

In article ,
Ron wrote:

How do I find the last number in a column of data and have it entered into
another cell?