» Find the last numeric value in a range in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
Text/Numeric data in column A
A1
A2 AAA
A3
A4 BBB
A5 CCC
A6 DDD
A7 502
A8 EEE
A9
A10
Formula in cell B1: {=INDEX(A1:A10,MATCH(9.99999999999999E+307,A1:A10))}
Result: 502
Please note:
The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter
Book Store:
Recommended Books:
- Microsoft Outlook 2002 for Dummies
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- The Basics of Finance: Financial Tools for Non Financial Managers
- The Interpretation of Financial Statements
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- The Ernst & Young Business Plan Guide
No comments have been submitted.
