Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Returning the last item in column
I'm stumped by something that seems simple. I have a column of data that is
added to each day. I want to take the last value in this column each day and enter in a daily summary row. My summary row contains sums and averages for other columns, but I just need the last value in this particular column to be transferred each day to the summary row. I can't find a formula or function to accomplish this seemingly simple task. Any suggestions greatly appreciated. |
#2
|
|||
|
|||
HondaMike, Will return the last numeric valve in Column A
=LOOKUP(9.99999999999999E+307,A:A) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "HondaMike" wrote in message ... I'm stumped by something that seems simple. I have a column of data that is added to each day. I want to take the last value in this column each day and enter in a daily summary row. My summary row contains sums and averages for other columns, but I just need the last value in this particular column to be transferred each day to the summary row. I can't find a formula or function to accomplish this seemingly simple task. Any suggestions greatly appreciated. |
#3
|
|||
|
|||
This might suffice for the purpose,
based on the conditions posted .. Suppose the column is col A, with data entered from row2 down successively (without leaving any blank rows in-between) Put in say, B1: =INDEX(A2:A100,MATCH(TRUE,(A2:A100=""),0)-1) Array-enter the formula, i.e. press CTRL+SHIFT+ENTER instead of just pressing ENTER B1 will return the last value entered in col A Adapt the range "A2:A100" to suit -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "HondaMike" wrote in message ... I'm stumped by something that seems simple. I have a column of data that is added to each day. I want to take the last value in this column each day and enter in a daily summary row. My summary row contains sums and averages for other columns, but I just need the last value in this particular column to be transferred each day to the summary row. I can't find a formula or function to accomplish this seemingly simple task. Any suggestions greatly appreciated. |
#4
|
|||
|
|||
More formulae than you can imagine
http://www.xldynamic.com/source/xld.LastValue.html -- HTH RP (remove nothere from the email address if mailing direct) "HondaMike" wrote in message ... I'm stumped by something that seems simple. I have a column of data that is added to each day. I want to take the last value in this column each day and enter in a daily summary row. My summary row contains sums and averages for other columns, but I just need the last value in this particular column to be transferred each day to the summary row. I can't find a formula or function to accomplish this seemingly simple task. Any suggestions greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |