Formula help *

  • Thread starter Thread starter JohnWA
  • Start date Start date
J

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
 
Sun said:
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
Click to expand...

=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?
 
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
Click to expand...


If column A:

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


--ron
 
Back
Top