|
|
| Maximum
based on a Single Criteria |
The
following formula returns the largest value from C2:C10, where the
corresponding value in B2:B10 equals the value in E2...
=MAX(IF(B2:B10=E2,C2:C10))
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
Based on the sample data, the formula returns 80. Sample
Workbook
|
|
|
