Last Number in Column

[paulrm906]

Hello everyone

I am currently using the formula =LOOKUP(9.99999999999999E+307,A:A) t
find the last number in a colmn (The above formula was thanks fro
Aladin) But unfortuneately it will not work if there are formulas i
the column. does anyone know how to solve this problem as I really d
need to keep this formula in that column.

Thankyou

Paul Maynard
Moscow

 

[Gary''s Student]

For alternative formulae see:

http://www.xldynamic.com/source/xld.LastValue.html#last_numeric

 

[paulrm906]

Thanks Gary's Student

It works great and the link as many useful formulas also

Thankyou

Paul Maynard