Gives the Nth smallest value in the data specified

Syntax of Excel Small formula:

In words:
=Find the smallest value(in this array, which is kth in the array mentioned)

Wheras K is the number. Thus making the argument 1st, 2nd, 3rd or 4th etc. If 4 is mentioned then Excel will find 4th smallest value from the data set mentioned as array in the formula.

Examples of Excel Small formula

=SMALL(sales,3) will return the third smallest number in the range named as “sales”