Hi

one option
=LOOKUP(2,1/(-A1:A26<0),A1:A26)

where your range is A1:A26
check out
http://www.xldynamic.com/source/xld.LastValue.html

for more options / details / explainations

Cheers
JulieD

"taylord" wrote in message
...
My spreadsheet contains the days of the month & I need the last value
entered
to display in a cell. ( not the total but the actual last value entered).
Thanks for any help!