Returning the last item in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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
Click to expand...
appreciated.
 
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 <at>yahoo<dot>com
----
HondaMike said:
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
Click to expand...
appreciated.
 
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 said:
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
Click to expand...
appreciated.
 
Back
Top