Formulas and Functions

“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
SMALL
The SMALL function returns the n
th
-smallest value within a range. The smallest value is
ranked number 1.
SMALL(num-date-dur-set, ranking)
 num-date-dur-set: A collection of values. num-date-dur-set is a collection
containing number, date, or duration values. All values must be of the same type.
 ranking: A number representing the size ranking of the value you want to retrieve.
ranking is a number value and must be in the range of 1 to the number of values in
the collection.
Usage Notes
A ranking of 1 retrieves the smallest number in the collection, 2 the second-smallest, Â
and so on. Values included in the collection that are of the same size are ranked
together, but impact the outcome.
Examples
Assume the following table contains the cumulative test scores for this semester for your 20 students.
(We have organized the data this way for the example; it would likely originally have been in 20
separate rows.)
=SMALL(A1:E4, 1) returns 30, the smallest cumulative test score (cell A1).
=SMALL(A1:E4, 2) returns 51, the second-smallest cumulative test score (cell E1).
=SMALL(A1:E4, 6) returns 75, the sixth-smallest cumulative test score (order is 30, 51, 68, 70, 75, then
75 again, so 75 is both the fth- and sixth-smallest cumulative test score).
Related Topics
For related functions and additional information, see:
“LARGE” on page 264
“RANK” on page 285
“Listing of Statistical Functions” on page 225
288 Chapter 10 Statistical Functions