Share this article:

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.