Microsoft Office Tutorials and References
In Depth Information
Using SMALL to Sequence a List in Date Sequence
Figure 14.3. The
SMALL function in column D finds the earliest years in the
function in column D finds the earliest years in the
This example contains a twist that makes the formula easier than in the ex-
ample for LARGE. In the initial formula in cell D2, the argument for kwas
generated using ROW(A1). This function returns the number 1. As the formula
is copied from cell D2 down to the remaining rows, the reference changes to
ROW(A2) and so on. This allows each row in column D to show a successively
larger value from array.
The formula in cell D2 is =SMALL($B$2:$B$19,ROW(A1)). After you have
found the year in column D, the formula in cell E2 to return the title is
=INDEX($A$2:$A$19,MATCH(D2,$B$2:$B$19,0)). This assumes there are no du-
plicates in column B.