Which function can I use to get the value of the last not empy cell in a row in Excel 2010?
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
Try this for indpendance from the active sheet



If you want a regular worksheet function, this might work... you do need to restrict the range, but this will provide the last number, last text string, or last anything. This example shows a column, but works the same for a row range: Number: =LOOKUP(2, 1/ISNUMBER($A$1:$A$30), $A$1:$A$30) Text: =LOOKUP(2, 1/ISTEXT($A$1:$A$30), $A$1:$A$30) Anything: =LOOKUP(2, 1/($A$1:$A$30<>""), $A$1:$A$30) 


Try this VBA function:
Likewise, this function will return the value of the last nonempty cell in a column:


