EXCEL SOLUTIONS

Rank students and find the top scores

Find who is first, who is second, and where each student stands.

IntermediateEducationAbout 7 minutes

Sample data

Row	A	B	C	D
1	Student	Maths	Science	English
2	Layla	78	85	91
3	Omar	62	70	58
4	Priya	95	88	92
5	Quinn	45	52	61
6	Rosa	88	79	84

Class scores (fictional) Row 1 holds the headings. All data is fictional. Dates are year-month-day.

Steps

Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.

Find the highest Maths score.
Result95
Find the second highest with LARGE.
Result88
Find a student’s position. Omar is in row 3.
Result4
Find the name of the top student with INDEX and MATCH.
ResultPriya
Find who needs support: the lowest score.
ResultQuinn
Count the students below 60 in Maths.
Result1

What to remember

MATCH finds where, INDEX returns what is there. Together they turn a number back into a name.

Formulas used

MAXLARGERANKINDEXMATCHCOUNTIF

Need Something Different? Let’s Talk.

Looking for different features or something built around your workflow? Share your idea with us.

Next lesson: Summarise salaries by department Let’s Talk All tutorials