» 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:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- The 11 Immutable Laws of Internet Branding
- Investing for Dummies, Third Edition
- Now, Discover Your Strengths
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
