I think you meant:
=INDEX(A1:A1000,COUNTA(A1:A1000))


"Peo Sjoblom" wrote:


=LOOKUP(2,1/(A2:A10000<""),A2:A10000)

if there are no blanks in-between

=INDEX(A1:A1000,COUNTA(A1000:A1000))



--
Regards,

Peo Sjoblom


"Amir" wrote in message
...
Hello to alll
I have 5 codes (contain text and number) in a column:
A1= F 01 01
A2= F 01 02
A3= F 01 03
A4= F 01 04
A5= F 01 05
But they are not completed at one time. they are completed at some times
orderly.
I need to see the latest filled cell (Latest code) in a cell on the other
worksheet.
Is there a function for it?
Much thnaks
Amir