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 …