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().