SMALL
Gives the Nth smallest value in the data specified
Syntax of Excel Small formula:
=SMALL(array,k)
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”