Show the latest Cell Value of a column in the other cell of worksh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=LOOKUP(2,1/(A2:A10000<>""),A2:A10000)

if there are no blanks in-between

=INDEX(A1:A1000,COUNTA(A1000:A1000))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count entries in the column translating to minutes. 5
Autofill dates not in contiguous cells 1
Finding the date in a table when one value first exceeds another. 1
sum of info in a range based on dates 4
Build a reference to another worksheet from cell values in currentsheet 3
return TRUE if a date falls between two dates 8
sumproduct with varying column ranges 1
Merge various cells value in one row into one cell 3

Back
Top