Excel Function of the Month – LARGE

The Excel Function of the month is



Returns the k-th largest value in a data set.


We know that MAX returns the highest number. But what if we want the second highest, or third or fourth highest? That’s where LARGE is very useful. Large only needs two things :

An array (data set) and what level of number you’re looking for. So, for example, to find the first, second and third highest numbers in an array, see this pic:


Check out my Excel posters for your classroom

Similar Posts: