| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show the latest Cell Value of a column in the other cell of wo
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show the latest Cell Value of a column in the other cell of worksh | Excel Worksheet Functions | |||
| Show the latest Cell Value of a column in the other cell of worksh | Excel Worksheet Functions | |||
| Getting a pivot table to show the count of blank cells in a worksh | Excel Discussion (Misc queries) | |||
| Reading the Latest Value into a cell | Excel Worksheet Functions | |||
| Selecting any cell in a column I want my ComboBox to show. How? | Excel Discussion (Misc queries) | |||
Hybrid Mode
