how can I get the last value entered into an excel column to disp.

[taylord]

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!

 

[JulieD]

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

 

[bj]

If you are interested in dates only
Have you tried
=max(rng) formated as a date
if the range is dates only this should give you the latest date listed.

If the dates are in one column 1 and you are interested in data next to that
column, that is a different question.

is there only one dtae per entry or can there be several dates entries for a
given date?