formula for last cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gwbdirect - 30 Apr 2008 17:46 GMT

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!!!

Reply to this Message

Mike H - 30 Apr 2008 17:51 GMT

For numeric values try

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

Change the column to suit

Mike

> I need a formula that will show the last cell in a range.
> 1000
[quoted text clipped - 3 lines]
> want to show 3000 as the result and not the total of everything in the
> column!!!

Reply to this Message

gwbdirect - 30 Apr 2008 21:40 GMT

thanks for your help. I will try this formula.

> For numeric values try
>
[quoted text clipped - 11 lines]
> > want to show 3000 as the result and not the total of everything in the
> > column!!!

Reply to this Message

Jim Thomlinson - 30 Apr 2008 17:52 GMT

Check out this link...

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

Signature

HTH...

Jim Thomlinson

> I need a formula that will show the last cell in a range.
> 1000
[quoted text clipped - 3 lines]
> want to show 3000 as the result and not the total of everything in the
> column!!!

Reply to this Message

gwbdirect - 30 Apr 2008 21:39 GMT

Thanks jim I will check it out.

> Check out this link...
>
[quoted text clipped - 7 lines]
> > want to show 3000 as the result and not the total of everything in the
> > column!!!

Reply to this Message

Rick Rothstein (MVP - VB) - 30 Apr 2008 18:12 GMT

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

>I need a formula that will show the last cell in a range.
> 1000
[quoted text clipped - 3 lines]
> want to show 3000 as the result and not the total of everything in the
> column!!!

Reply to this Message