» Returning the Entire Contents of the Row Containing the Highest Math Grade
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Each row of columns B:E contains data on a student's ID, year, subject, and grade.
We want to find the highest math mark in the data range and retrieve all the information from that particular row.
Solution:
Use the INDEX, MATCH, and MAX functions as shown in the following Array formula:
{=INDEX(B2:B6,MATCH(MAX(($E$2:$E$6)*($D$2:$D$6="Math")),$E$2:$E$6,0))}
Copy the formula from cell B8 to cells C8:E8.
Book Store:
Recommended Books:
- The Analysis and Use of Financial Statements
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The 22 Immutable Laws of Branding
- Business Plans For Dummies®
- Dictionary of Finance and Investment Terms
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.


