Gives the Nth largest number in the range specified

Syntax of Excel Large Formula:

In words:
=Give the largest number(in this data, which kth in the data specified)

Wheras K is the number. Thus making the argument 1st, 2nd, 3rd or 4th etc. If 4 is mentioned then Excel will find 4th largest value from the data set mentioned as array in the formula.

Examples of Excel Large formula

=LARGE(sales,6) will return the 6th largest number in the range named as “sales”