Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is another question that requires layman explanation(for Small Function).
I just can't figure out how to operate the function. I found the Small function in this Formula: =IF(ISERROR(SMALL(Data!$F:$F,ROWS($A$1:A1))),"", INDEX(Data!A:A, MATCH(SMALL(Data!$F:$F,ROWS($A$1:A1)),Data!$F:$F,0 ))) -Max xl 97.- --------------------------------------------------- --Extracted from the HELPER!-- SMALL Returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set. Syntax SMALL(array,k) Array is an array or range of numerical data for which you want to determine the k-th smallest value. K is the position (from the smallest) in the array or range of data to return. Remarks If array is empty, SMALL returns the #NUM! error value. If k ‰¤ 0 or if k exceeds the number of data points, SMALL returns the #NUM! error value. If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value. Example SMALL({3,4,5,2,3,4,5,6,4,7},4) equals 4 SMALL({1,4,8,3,7,12,54,8,23},2) equals 3 I am even more confused after this. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Small Array is too big for AVERAGE Function? | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Adding cells with the same color, sub works but function doesnt | Excel Discussion (Misc queries) | |||
What function to determine the second small integer from a list? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions |