» 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:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Finance and Accounting for Nonfinancial Managers
- Marketing Management
- Not-for-Profit Accounting Made Easy
- Keys to Reading an Annual Report (Barron's Business Keys)
- Getting to Yes: Negotiating Agreement Without Giving In
No comments have been submitted.
