Return the Last Text Value
The following formula returns the last text value from A2:A10...
=LOOKUP(REPT("z",255),A2:A10)
Based on the sample data, the formula returns "C".
Sample Workbook: Download
The following formula returns the last text value from A2:A10...
=LOOKUP(REPT("z",255),A2:A10)
Based on the sample data, the formula returns "C".
Sample Workbook: Download