| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine last cell in a row
I am a new user. Please help with the following
How can I reference the last cell updated with numbers in a raw? example colum a b c d e f are days on raw number 2. I like to have the last day updated number on column g. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determine last cell in a row
How can I reference the last cell updated with numbers in a raw?
This will return the rightmost numeric value from the referenced range: =LOOKUP(1E100,A1:F1) -- Biff Microsoft Excel MVP "sutha" wrote in message ... I am a new user. Please help with the following How can I reference the last cell updated with numbers in a raw? example colum a b c d e f are days on raw number 2. I like to have the last day updated number on column g. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| determine which cell is the max count | Excel Discussion (Misc queries) | |||
| Determine Value of Cell? | Excel Worksheet Functions | |||
| Is there a way to determine which cell the function =min() used? | Excel Worksheet Functions | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
Linear Mode
