Tip Printed from ExcelTip.com
Get the value of the last non blank cell in a column in Microsoft Excel


In cells A1:A4, the following values appear

A1
AAA
A2
BBB
A3
CCC
A4
DDD
A5
AAA
A6
CCC
A7
AAA
A8
BBB
A9
DDD
A10
AAA
A11
CCC
A12
AAA
A13
DDD
A14
DDD

Enter the following formula in cell B1: =OFFSET(A1,COUNTA(A:A)-1,0)

The result: DDD