In this video we'll look at how to calculate the "nth" smallest or largest values in a range using the SMALL or LARGE functions. This would be, for example, the 1st, 2nd, and 3rd smallest or largest values.
In this first sheet, we have a list of students with five test scores. I'll use the LARGE function to extract the three best scores for each student.
To get top values, use the LARGE function. The LARGE function needs an array and something called "k" which you can think of as "nth".
So, in this case, I'll just point at the five scores for the array and enter "1" for k. This gives us the top score for the first student.
The Excel LARGE function returns numeric values based on their position in a list when sorted by value. In other words, it can retrieve "nth largest" values - 1st largest value, 2nd largest value, 3rd largest value, etc.
The Excel SMALL function returns numeric values based on their position in a list ranked by value. In other words, it can retrive "nth smallest" values - 1st smallest value, 2nd smallest value, 3rd smallest value, etc.