» Finding the Largest Number among Those Meeting Specified Criteria
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Column A contains 5-digit numbers.
We want to find the largest number from the list whose first two digits are "11".
Solution:
Use the MAX, LEFT, and TEXT functions in the following Array formula:
{=MAX((LEFT(A2:A6,2)=TEXT(C2,"@"))*A2:A6)}
Book Store:
Recommended Books:
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Access Version 2002 Step by Step
- The Guide to Understanding Financial Statements
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Special Edition Using Microsoft Excel 2002
- Personal Finance for Dummies
No comments have been submitted.
