Let's say I have a sheet of student data.
- column A: grade level
- column B: student name
- [not relevant: columns C - G: absences, parents' phone number, credits completed, etc]
- column H: GPA
I want to find the highest GPA in each grade level and return the GPA and the name of the student associated with that GPA. How would I do that in Google Sheets?
I know how to return the highest GPA by grade level using a query but I don't know how to return a value from another column (name) along with it.