Excel formula: Get value of last non-empty cell | Exceljet

exceljet.net

To find the value of the last non-empty cell in a row or column, you can use the LOOKUP function in this surprisingly compact formula. As an …

View on exceljet.net