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

S

sunroyal

i was try ing to figure out how to get this particular formula:

=INDEX(A:A,COUNTA(A:A))

or this one:

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

to recognize time formatted cells that have a h:mm:ss value.

I hope thats clearer, I've spent the last two hours with my kid all
over me, I was a little vague, sorry.

Lane


__________________
Thanks,

Lane
 
P

Peo Sjoblom

This will return the last numeric entry in A and
since times (hh:mm) are numeric it should work

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