SMALL(array, position) returns the k-th smallest value in a data set : SMALL « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. SMALL
Input the formula: =SMALL(A2:A10,4). Press Enter to get the result.
Input the formula: =SMALL(A2:A10,4)
21.66.SMALL
21.66.1.SMALL(array, position) returns the k-th smallest value in a data setSMALL(array, position) returns the k-th smallest value in a data set