News Update :
Home » » K.ESIMO.MAYOR Y K.ESIMO.MENOR

K.ESIMO.MAYOR Y K.ESIMO.MENOR

By: omer nawaz on Wednesday, 31 December 2014 | 02:21

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.

Post a Comment

 
Contact Us | Privacy policy | Term of use | Advertise with Us | Site map
Copyright © 2011. Blogging Brain . All Rights Reserved.
Design Template by Blogging Brain | | Powered by Blogger