Returning the last item in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HondaMike - 04 Jan 2005 03:35 GMT

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 to this Message

Paul B - 04 Jan 2005 03:42 GMT

HondaMike, Will return the last numeric valve in Column A

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

Signature

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

> 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 to this Message

Max - 04 Jan 2005 03:48 GMT

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

Signature

--
Rgds
Max
xl 97
---
GMT+8, 1? 22' N 103? 45' E
xdemechanik <at>yahoo<dot>com
----

Reply to this Message

Bob Phillips - 04 Jan 2005 11:20 GMT

More formulae than you can imagine

http://www.xldynamic.com/source/xld.LastValue.html

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

Reply to this Message