» Finding the Largest Number among Those Meeting Specified Criteria
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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:
No comments have been submitted.
