![]() (I) Example with duplicate values in Arrayġ. ![]() If argument Array is empty and k is less than or equal to 0 or k is greater than the number of values in the Array, Small function returns the numeric error value #NUM!. ![]() Let's first study the basic usage of the Small function, and then study the extended application combined with each function. It has only two arguments, one is Array and the other is k, k cannot be less than or equal to 0 and cannot be greater than the total number of array elements, otherwise an error is returned.Įxcel Small functions is often combined with Index, IF, Match, and Row functions to achieve one-to-many lookups on the one hand and filter duplicate values on the other hand. The Excel Small function is used to return a specified value in an array or a reference cell sorted from small to large, such as the first minimum, the second minimum, and so on.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |