Formula help *

[JohnWA]

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

 

[Stan Brown]

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)


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

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

=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