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.

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.

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.

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.