The Excel LARGE function returns the largest numeric value from the numbers that you provided. The steps are as follows. Or returns the largest value in the array.
Click on More Functions tab.
As a worksheet function the LARGE function can be entered as part of a formula in a cell of a worksheet. To sort data we combine the LARGE function with the ROW function. For example the LARGE function can find the first second third or nth smallest value in a list or an array. The SMALL Function is categorized as an Excel Statistical function.