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.