SMALL

Definition: The SMALL function in Excel is used to find the k-th smallest value in a range of data.

Syntax: ==SMALL(array, k).

Situation: This formula is appropriate in situations where you need to find the k-th smallest value in a range of data.

Example: If you have a range of data A1:A10 and you want to find the 3rd smallest value, you would use the formula =SMALL(A1:A10, 3). This would return the 3rd smallest value in the range.