1. Introduction to the SMALL Function
The SMALL function in Excel is a practical tool for finding the n-th smallest number in a dataset. This function is particularly useful in scenarios such as determining the lowest sales figures, identifying the lowest priced products, or analyzing performance metrics.
2. Parameters of the SMALL Function
Here is the syntax for using the
SMALL function.=SMALL(array, k)array: required An array or range of numerical data for which you want to determine the k-th smallest value. k: required The position of the data to return within the array or range (starting from the smallest value). 3. Example Scenario
Assume we have a set of sales data, and we want to find the three lowest sales figures.
4. Getting Started with the SMALL Function
Type on the keyboard:
=SMALL(
5. Select the Dataset Range
At this point, the function will prompt to select the dataset range. Click on the starting point of the dataset
B5, then hold down the Shift key and click on the end of the dataset C9, then input the number 1 to get: =SMALL(B5:C9, 1).
6. Activating the SMALL Function
This successfully retrieves the lowest sales figure. The lowest sales figure is: 3000.
7. The n-th Smallest
Similarly, changing the parameter k to 2 and 3 allows you to calculate the second smallest and third smallest values.
8. 🎉 Finish! 🎉
Author's Note: I hope you can feel the effort I put into these tutorials. I hope to create a series of very easy-to-understand Excel tutorials.If it is useful, help me share these tutorials, thank you!
Follow me: