LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Formular to read the last entry in a column

I am trying to calculate a "latest result" in which I need to read the last
(Not greatest or smallest) figure in a column:
e.g. column H has five figures in it, 100, 75, 70, 50, 65. I want a cell
that will show me the answer or 65, and if another figure is added
afterwards, for my latest result cell to show whatever is in this figure.

How can I do this???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code to read formular from another cell fLiPMoD£ Excel Discussion (Misc queries) 1 April 25th 07 12:12 AM
inserting a row into a column that is read on another worksheet Max Excel Worksheet Functions 3 January 10th 07 11:18 PM
Transpose row to read to column Tiesthatbind Excel Worksheet Functions 7 July 12th 06 10:39 AM
how can i change column to read a.b.c.etc and not 1.2.3. Column Chris Excel Discussion (Misc queries) 2 April 6th 06 10:35 AM
Formula to read two column come back with one value? Barbie Excel Worksheet Functions 1 February 17th 05 09:57 PM


All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"