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.
|