What it does: The LARGE() Function provides the n-th largest piece of data from an array.
Plain English: The LARGE() Function is similar to MAX(), but what if instead of the largest piece of data in a set, you wanted the 2nd largest? Or 10th largest? You can do it with LARGE().
Arguments: LARGE(array, n)
- Array – the array of data you want to find the n-th large number from
- n – The position from the largest that you’d like to generate. I.e. a “3” here would yield the 3rd largest number.