LARGE Function Explained
The LARGE function in Microsoft Excel returns the nth largest value from a range of values. It takes two arguments: an array of values and a number n that specifies which value to return. The LARGE function is useful for finding the highest or lowest values in a range of data.
LARGE Function Syntax
LARGE(array, k)
- array: The range of cells to consider when looking for the kth largest value.
- k: The position (from the largest) in the array or range of cells to return.