formula for last cell

[gwbdirect]

I need a formula that will show the last cell in a range.
1000
2000
3000

want to show 3000 as the result and not the total of everything in the
column!!!

 

[Mike H]

For numeric values try

=LOOKUP(9.99999999999999E+307,A:A)

Change the column to suit

Mike

 

[Jim Thomlinson]

Check out this link...

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

 

[Rick Rothstein \(MVP - VB\)]

This appears to return the contents of the last cell in a specified column
whether that cell holds a number or text...

=LOOKUP(2,1/(A1:A65535<>""),A:A)

Rick

 

[gwbdirect]

Thanks jim I will check it out.

Check out this link...

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

 

[gwbdirect]

thanks for your help. I will try this formula.

For numeric values try

=LOOKUP(9.99999999999999E+307,A:A)

Change the column to suit

Mike