SMALL

Syntax:

SMALL ( array , k )

Description: Computes the kth smallest value in a data set.

Arguments:

Name

Type

Description

array

array, reference

The set of numbers from which the kth-smallest value is to be determined.

k

number

The position (from the smallest) in the array or cell range of data to return.

Return Type and Value: number – The kth smallest value in a data set.

However, if

  • array is empty, the return value is unspecified.

  • k ≤ 0 or k is greater than the number of data points, #NUM! is returned.

example: