lookup format

L

Lane

I am currently using the below formula to return the value of the las
cell entered in a column. I have tried to get it to return a tim
value, but i cannot get it to work. Can anyone tell me how to get thi
to return a time?


=LOOKUP(REPT("z",255),A2:A10000)

Thanks, all
 
P

Peo Sjoblom

Use this instead

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

or for either text or numbers you can use

=INDEX(A:A,MAX((A1:A10000<>"")*ROW(INDIRECT("1:10000"))))

entered with ctrl + shift & enter

note that you have to format the cell for time or else you will get the
numeric time value
like 0.5 for 12:00 etc
 
Top