SMALL Function

The SMALL function is a function in Microsoft Excel that returns the nth smallest value in a range of cells. It takes two arguments: an array or range of cells, and a number indicating which smallest value to return.

For example, if you have a range of cells containing the values 1, 2, 3, 4, 5, and you want to find the second smallest value, you would use the SMALL function as follows:

=SMALL(A1:A5, 2)

This would return the value “2,” as it is the second smallest value in the range.

The SMALL function is useful for finding the nth smallest value in a range of data, sorting data in ascending order, or for finding the median value in a range of data.

Download the sample files: SMALL FUNCTION – Click here