Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to return the value of the last nonblank cell in a row?
Does anyone know of a method to return the value of the last nonblank cell in
a row? I have a running total spreadsheet that contains links to other workers, the value that I need in the reference cell has to be the last value in the row, it may be b22 then next time c22, d22 etc all suggestions appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to return the value of the last nonblank cell in a row?
One way to match any number larger than possible in your row.
=INDEX(3:3,MATCH(9999999,3:3)) -- Don Guillett SalesAid Software "WINDMILL" wrote in message ... Does anyone know of a method to return the value of the last nonblank cell in a row? I have a running total spreadsheet that contains links to other workers, the value that I need in the reference cell has to be the last value in the row, it may be b22 then next time c22, d22 etc all suggestions appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to return the value of the last nonblank cell in a row?
Use this: =INDIRECT(ADDRESS(MAX((DataRange2<"")*ROW(DataRan ge2)),
COLUMN(DataRange2),4)) See here for more info: http://www.cpearson.com/excel/excelF.htm , under the section titled Finding the Used Part of a Range Dave -- Brevity is the soul of wit. "WINDMILL" wrote: Does anyone know of a method to return the value of the last nonblank cell in a row? I have a running total spreadsheet that contains links to other workers, the value that I need in the reference cell has to be the last value in the row, it may be b22 then next time c22, d22 etc all suggestions appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value in cell above the reference | Excel Discussion (Misc queries) | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |