Excel 2013 Tutorial - How to Get the Nth Largest or Smallest Value
In this tutorial you will learn :
How to Get the Nth Largest or Smallest Value.
The MIN and MAX functions used in the previous tutorial are great for finding the largest and smallest values. But sometimes you need to find the second largest or the fifth smallest value.
=LARGE($C$3:$C$14,ROW(A3))
A3 - third larger
Another way to determine the Nth largest or smallest number is the RANK function.
The RANK function takes three arguments: the number to be ranked; the list of all the numbers; and the sort order.