Microsoft Office Tutorials and References

In Depth Information

**Using SMALL to Sequence a List in Date Sequence**

Figure 14.3.

Figure 14.3.
The

The SMALL

SMALL function in column D finds the earliest years in the

function in column D finds the earliest years in the

list.

list.

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.