LARGE
Gives the Nth largest number in the range specified
Gives the Nth largest number in the range specified
Syntax of Excel Large Formula:
=LARGE(array,k)
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.
=LARGE(sales,6) will return the 6th largest number in the range named as “sales”