ExcelHeroThe LARGE function
Returns the k-th largest value.
In German Excel: KGRÖSSTE
How to write it
=LARGE(array, k)- array
- The range.
- k
- 1 is the largest, 2 the second largest…
💡 LARGE(r,1) is the same as MAX(r).
Try it
What is the second best score?
A
B
1
Student
Score
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
8
2nd best
=LARGE(range, 2).