LARGE

Definition: LARGE is a function that returns the nth largest value in a data set.

Syntax: =LARGE(array, k)

Situation: This formula is appropriate when you need to find the nth largest value in a data set.

Example: If you have a set of numbers 2, 4, 6, and 8, and want to find the second largest value, the formula =LARGE(A1:A4, 2) can be used, which returns 6.