Small

Syntax

Small(Data, Position)

Data. Data array, for which you want to find the k-th least value.

Position. Position (starting from the smallest) in an array or data cell range. Available values are taken from the (0, length Data] range.

The method returns k-th least value in a data set.

This function is used to return values with a particular relative standing in a data set.

If n is the number of data points in Data, then Small(Data; 1) is the smallest value and Small(Data; n) is the greatest value.