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.