Thread: Last Cell Info
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ed Davis Ed Davis is offline
external usenet poster
 
Posts: 58
Default Last Cell Info

The sell that I put this formula in stays blank.
Thanks for your help though.

"Domenic" wrote in message
...
For the last numerical value, try...

=LOOKUP(9.99999999999999E+307,F1:F53)

Hope this helps!

In article ,
"Ed Davis" wrote:

I have a column lets call it F that has 53 rows.
Numbers go into the cell after something is entered in another column so
it
is a formula.

I want to use the last number in that F column. It may be in any row from
1
through 53.

Is there a way to get that number.

Thanks in advance
Ed Davis