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:
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!