K.ESIMO.MAYOR Y K.ESIMO.MENOR

LARGE

Returns the k - th largest value of a dataset . This may be used to select a value based on their relative position. For example, you can use LARGE to return the highest value of a result, the second result or third.


syntax

LARGE (array, k)





Array is the array or range of data the k - th largest value you want to determine.
K represents the position (from the higher value ) within the array or range of cells, the data to be returned.


K.ESIMO.MENOR


Returns the k - th smallest value of a dataset. Use this function to return values ​​with a specific relative position within a data set.

syntax

SMALL (array, k)

Array is an array or range of numerical data whose k - th smallest value you want to determine .
K is the position within the array or range of data, the data to be returned, determined from the smallest value.