» 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:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Business Analysis with Microsoft Excel (2nd Edition)
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
