Lookup the Last Value
The following formula returns the last value, whether numerical or text, from A2:A10...
=LOOKUP(2,1/(A2:A10<>""),A2:A10)
Based on the sample data, the formula returns "C".
Sample Workbook: Download
2009 - 2016
2009 - 2016
The following formula returns the last value, whether numerical or text, from A2:A10...
=LOOKUP(2,1/(A2:A10<>""),A2:A10)
Based on the sample data, the formula returns "C".
Sample Workbook: Download