uplink600, this return the last numeric valve in A1:A365,
=LOOKUP(9.99999999999999E+307,A1:A365)
you may also want to have a look here for more information on finding the
last cell
http://www.xldynamic.com/source/xld.LastValue.html
--
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
"uplink600" wrote
in message ...
Hi
Can you please advise the easiest method to achieve the following.
I need a formula to perform a calculation using the last cell in a
range that contains a value. The range would be say A1:A365 and each
day the user will add to the bottom of the range (for each day of the
year) and I need to calculate from this on a rolling basis (basically a
yearly average).
I hope this is easy to understand.
Thanks
VC
--
uplink600
------------------------------------------------------------------------
uplink600's Profile:
http://www.excelforum.com/member.php...fo&userid=9408
View this thread: http://www.excelforum.com/showthread...hreadid=520998