| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Last Value in a Row formula
I am using this formula:
=INDEX(1:1,MAX(INDEX(COLUMN(1:1)*(NOT(ISBLANK(1:1) )),))) to get the last non-blank value in my current worksheet. Does anyone know how to use this formula to get the last rnon-blank value of a different workbook? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No return for formula | Excel Worksheet Functions | |||
| Formula to Return Last Non-Zero Value in Row | Excel Worksheet Functions | |||
| I Need a Formula to return a zero value | Excel Worksheet Functions | |||
| Why does my formula return zero? | Excel Discussion (Misc queries) | |||
| I need help with way to return 0 or N/A to a formula | New Users to Excel | |||
Threaded Mode
