SheetFX
≡
<< Go back to all functions

SMALL

The SMALL function in Google Sheets returns the nth smallest element from a data set, where n is user-defined. It is a useful tool for analyzing data and extracting specific values based on their position in a dataset.

Function Syntax and Parameters

Syntax: SMALL(data, n)

Parameters:

  • data: The data set from which to extract the nth smallest value.
  • n: The position of the value to be extracted.

Step-by-Step Tutorial

  1. Using SMALL with a range of cells:
    • Example: If A1:A5 has the values 5, 10, 3, 8, 7 and you want to extract the 2nd smallest value, you can use the formula =SMALL(A1:A5, 2), which will return 5.

Use Cases and Scenarios

  1. Data Analysis: Extract the lowest price from a list of products.
  2. Ranking: Determine the nth place finisher in a race.
  3. Grades: Find the nth lowest grade in a class.

Related Functions

  • LARGE: Find the nth largest element from a data set.

Related Articles