Microsoft Office Tutorials and References
In Depth Information
Using SMALL to Sequence a List in Date Sequence
Using
Using SMALL
SMALL to Sequence a List in Date Sequence
to Sequence a List in Date Sequence
The MIN function finds the smallest value in a data set. The SMALL function
can find the kth smallest value. This can be great for finding not just the
smallest value but the second-smallest, third-smallest, and so on. If nis
the number of data points in an array, SMALL(array,1) equals the smallest
value, and SMALL(array,n) equals the largest value.
Syntax
=SMALL(array,k)
The SMALL function returns the kth smallest value in a data set. You use
this function to return values with a particular relative standing in a data
set. arrayis an array or a range of numeric data for which you want to de-
termine the kth smallest value. If arrayis empty, SMALL returns a #NUM!
error. kis the position (from the smallest) in the array or range of data to
return. If kis less than or equal to 0 or if kexceeds the number of data points,
SMALL returns a #NUM! error.
In Figure 14.3 , range A2:B19 contains a list of book titles and their publica-
tion dates. To find the earliest dates for the books, you use =SMALL().
Search JabSto ::




Custom Search