Google Sheets SMALL Function: Syntax, Examples & Tips

data:
The range of cells or array from which you want to find the smallest value.

n:
The position (rank) of the smallest value you want to return, where 1 represents the smallest value, 2 represents the second smallest value, and so on.

What is a SMALL Function?

The SMALL function in Google Sheets is a useful tool that allows you to find the k-th smallest value in a dataset. This function is particularly helpful when you want to analyze data and extract specific values based on their rank. It can be used in various scenarios, such as finding the lowest scores in a list, identifying the smallest expenses, or any situation where you need to focus on the lower end of a data set.

In simpler terms, SMALL helps you to pinpoint specific low values in a range of numbers, making it easier to analyze and interpret your data.

A Practical Example

Imagine you are managing a list of student scores in a class:

Scores Table:

You want to find the second lowest score in the class.

SMALL Formula

To achieve this, you would use the SMALL function as follows:

=SMALL(A2:A6, 2)

In this formula:

• A2:A6 is the range containing the scores you want to analyze.
• 2 indicates that you want to find the second smallest value in that range.

Result of the Formula

When you apply the SMALL formula to the Scores Table, the output would be:

In this case, the formula returns 85, which is the second lowest score in the list.

Why Use SMALL?

The SMALL function is beneficial because it simplifies the process of identifying specific low values in a dataset. It allows you to easily rank and retrieve values without having to sort the entire dataset manually. This can save time and enhance your data analysis capabilities.

Key Takeaways:

• SMALL: A function that returns the k-th smallest value from a dataset.
• Versatile: Useful for various applications, including ranking scores, expenses, and other numerical data.
• Efficiency: Saves time by allowing you to extract specific values without sorting the entire dataset.
• Common Use Cases: Ideal for academic performance analysis, financial data evaluation, and any scenario where low values are of interest.

The SMALL function is an essential tool for anyone working with numerical data in Google Sheets, providing a straightforward way to enhance data analysis and reporting capabilities.

Happy spreadsheeting!