» 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:
- Marketing Management
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Accounting and Financial Fundamentals for Nonfinancial Executives
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
No comments have been submitted.
