Return the Last Numerical Value
The following formula returns the last numerical value from A2:A10...
=LOOKUP(9.99999999999999E+307,A2:A10)
Based on the sample data, the formula returns 4.
Sample Workbook: Download
The following formula returns the last numerical value from A2:A10...
=LOOKUP(9.99999999999999E+307,A2:A10)
Based on the sample data, the formula returns 4.
Sample Workbook: Download