Formula help *

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnWA - 10 Feb 2008 11:53 GMT

Office 2007 I am trying to display in a cell the last value in a selected
column. Numbers are added daily to this column but I need this specific cell
to show the last entry at all times - any ideas or help would be appreciated

Thanks in advance Bryan

Reply to this Message

Stan Brown - 10 Feb 2008 12:28 GMT

Sun, 10 Feb 2008 20:53:28 +0900 from JohnWA <j_ustforfun@hotmail>:

> Office 2007 I am trying to display in a cell the last value in a selected
> column. Numbers are added daily to this column but I need this specific cell
> to show the last entry at all times - any ideas or help would be appreciated

=OFFSET($A$1,COUNTA($A:$A),0,1,1)

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

Reply to this Message

Ron Rosenfeld - 10 Feb 2008 12:58 GMT

>Sun, 10 Feb 2008 20:53:28 +0900 from JohnWA <j_ustforfun@hotmail>:
>> Office 2007 I am trying to display in a cell the last value in a selected
>> column. Numbers are added daily to this column but I need this specific cell
>> to show the last entry at all times - any ideas or help would be appreciated
>
>=OFFSET($A$1,COUNTA($A:$A),0,1,1)

Note that this will return either text or a number, and also requires that
there be NO blanks.
--ron

Reply to this Message

Ron Rosenfeld - 10 Feb 2008 12:57 GMT

>Office 2007 I am trying to display in a cell the last value in a selected
>column. Numbers are added daily to this column but I need this specific cell
>to show the last entry at all times - any ideas or help would be appreciated
>
>Thanks in advance Bryan

If column A:

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

--ron

Reply to this Message