Returns the largest value in a data set based upon the index. This function is used to determine an amounts order within a group of amounts. For example, you can use LARGE to return the largest, second largest or third-largest amount.

LARGE(Index, Amount #1, Amount #2, Amount #3, ...)

Index: which rank within the array you want to return.

Amount #1, Amount #2, Amount #3, ...: amounts to evaluate when determining rank.

If there are less than two arguments contained within parenthesis, 0 is returned

If the index is greater than the number of amounts, the lowest value is returned

LARGE(3, 25, 50, 75, 100): returns 50, the third largest value