Share this article:

What it does: The SMALL() Function provides the n-th smallest piece of data from an array.

Plain English: The SMALL() Function is similar to MIN(), but what if instead of the smallest piece of data in a set, you wanted the 2nd smallest? Or 10th smallest? You can do it with SMALL()

Arguments: SMALL(array, n)

  • Array – the array of data you want to find the n-th smallest number from
  • n – The position from the smallest that you’d like to generate. I.e. a “2” here would yield the 2nd smallest number.