Formuala to calculate from last cell in range containing value
 

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

Formuala to calculate from last cell in range containing value
 

The last value can be found using

=INDEX(A1:A365,MATCH(9.99999999999999E+307,A1:A365 ))

if you just want the row, just use

=MATCH(9.99999999999999E+307,A1:A365)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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

Formuala to calculate from last cell in range containing value
 

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