ExcelHeroThe SMALL function
Returns the k-th smallest value.
In German Excel: KKLEINSTE
How to write it
=SMALL(array, k)- array
- The range.
- k
- 1 is the smallest.
💡 SMALL(r,1) is the same as MIN(r).
Try it
What is the third lowest 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
3rd lowest
=SMALL(range, 3).