Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Gives the Nth smallest value in the data specified
Syntax of Excel Small formula:
=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.
=SMALL(sales,3) will return the third smallest number in the range named as “sales”