What is SMALL?
Returns the k-th smallest value in a dataset. Useful for finding minimum values, bottom performers, and threshold analysis.
Syntax
=SMALL(array, k)
Example
Formula: =SMALL(A1:A10, 3)
Result: Third smallest value
How It Works
Returns the 3rd smallest value in the range. SMALL(range, 1) equals MIN. Use for bottom-N analysis and identifying low values.