SMALL

Try it

When to use it

When should I use SMALL instead of MIN?

MIN gives only the single lowest value. SMALL returns the k-th smallest, so SMALL(range, 1) equals MIN, SMALL(range, 2) is the second lowest, and so on. Use it for bottom-N reporting.

How do I find the lowest few values?

Call SMALL with rank 1, 2, 3, and so on. SMALL(range, 2) returns the second smallest value, which is useful when you want to skip a single extreme low.

Use cases

Lowest score from a list of grades

Second-cheapest measured value

Used in

operations · education · science

Syntax

SMALL(array,k)

Examples

=SMALL({3,1,4,1,5,9,2,6},4) // => 3
=SMALL({3,1,4,1,5,9,2,6},1) // => 1
=SMALL({3,1,4,1,5,9,2,6},8) // => 9