The SMALL() function returns an argument in the nth position of an array of values arranged in accending order of thier value. The syntax for the function is =SMALL(array, nth_position ). The arguments "array" can be numerical values, a reference to a range of cells or a named range which you want to arrange in order of value. The "n_position" is the relative position you wish to find. The SMALL function can asess the value of elements in the array, organize them into list of data values in acending order (from the smallest value to the the largest) then isolate and return the nth term in the liste. For example: SMALL({6,8,2,7,3}, 2) = 3 as the array of values {6,8,2,7,3} when arranged in ascending order becomes {2,3,6,7,8} and the 2nd element is the number 3.

How to use the SMALL() function: Type " =SMALL( " Enter the coordinates for the range of values in the "array" e.g. "A2:A10". Type a comma. Enter the "nth_position" you want to find e.g."3". Type")" then press the "Enter" key.

The difference between RANK, LARGE and SMALL functions The LARGE function orders a list of values from largest to smallest, the SMALL function orders the values from smallest to largest. However the RANK function can returns the position number of a value in the list of data values in either decending or acending order depending on the parameters set by the user. Note: The SMALL function ignores non numeric values referenced in the arrag. Additionally if the nth_ position entered into the function is larger than the number of elements in the array the function will return a #NUM! error. Ranking without repetitive results