=LOOKUP(2,1/(A1:A200<""),A1:A200)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ssipiora" wrote in
message ...

I'd like to create a formula that always uses the last number in a
column for a calculation. That way when I add new daily data I
automatically get my calculation.

I'd rather not have another column doing this because I just need one
number, I just need it updated every day based on additional data.

Thanks


--
ssipiora
------------------------------------------------------------------------
ssipiora's Profile:
http://www.excelforum.com/member.php...o&userid=35195
View this thread: http://www.excelforum.com/showthread...hreadid=549608