SMALL Function

The Excel SMALL function returns a numeric value based on its position in a list when sorted by value in ascending order. In other words, SMALL can return the "nth smallest" value (1st smallest value, 2nd smallest value, 3rd smallest value, etc.) from a set of numeric data.

April 14, 2025 · 1 min · 94 words · Dr. Alexander Hill

Table of Contents

from a set of numeric data.

The SMALL function takes twoarguments,arrayandk.Arrayis anarrayorrangeof numeric values.

The argumentkrepresents position or rank.

Excel formula: Biggest gainers and losers

For example, to return the smallest value inarray, provide 1 fork.

To return the fifth smallest value inarray, provide 5 fork.

To get nthlargestvalues, see theLARGE function.

Excel formula: Multiple matches into separate columns

RANK can rank values from largest to smallest (i.e.

top sales) as well as smallest to largest (i.e.

MIN Function

The Excel MIN function returns the smallest numeric value in the data provided.

Excel formula: Get nth match with INDEX / MATCH

The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel formula: Sum bottom n values

Excel formula: Highlight 3 smallest values with criteria

Excel formula: Find lowest n values

Excel formula: nth smallest value with criteria

Excel formula: nth smallest value

Excel formula: Sort numbers ascending or descending

Excel formula: Sum bottom n values with criteria

Excel formula: Highlight bottom values

Excel formula: Get nth match

Excel formula: Multiple matches into separate rows

Excel formula: Minimum value

Excel formula: Break ties with helper column and COUNTIF

Excel LARGE function

Excel RANK function

Excel MIN function