The LARGE function allows you to extract the highest value in a range of numbers, as well as the second highest, the third highest, fourth highest…….and so on, and so forth, infinitim (I think that’s a word!).

As you can see from the image above, we have a range of numbers. I want to extract the highest, then the second highest, and so on. Therefore, we use the LARGE formula which is defined as follows:

=LARGE(A,B)

A = The range in which you want to extract numbers from

B = Which highest you want to extract where 1 is the highest value

That’s it. Enjoy!