» 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:
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Microsoft Outlook 2002 for Dummies
- Getting to Yes: Negotiating Agreement Without Giving In
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
