» 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:
- Getting to Yes: Negotiating Agreement Without Giving In
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Business Plans Kit for Dummies (With CD-ROM)
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Microsoft Windows XP Step by Step (With CD-ROM)
No comments have been submitted.
