Exceljet

Quick, clean, and to the point

Excel SMALL Function

Excel SMALL function
Summary 

The Excel SMALL function returns numeric values based on their position in a list ranked by value. In other words, it can retrive "nth smallest" values - smallest value, 2nd smallest value, 3rd smallest value, etc.

Purpose 
Get the nth smallest value
Return value 
The nth smallest value in the array.
Syntax 
=SMALL (array, n)
Arguments 
  • array - A range of cells from which to extract smallest values.
  • n - An integer that specifies the position from the smallest value, i.e. the nth position.
Usage notes 

The SMALL function is useful when you want to retrieve the nth lowest value from a set of data — for example, the first, second, or third fastest times in a race.

Like LARGE, the SMALL function retrieves numeric values based on their position in a list when sorted by value.

Note: Microsoft documentation refers to "k" instead of "n". We use n because "nth" is much easier to say.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.