How to Use the SMALL Function in Excel
The SMALL Function in Excel is not just a tool, but a crucial element in data analysis. It equips users with the ability to extract the smallest values from a dataset, making it invaluable for identifying bottom performers, finding the least values, or ranking data in ascending order. This Excel Function Explained Video Series will guide you through the syntax, usage, and practical applications of the SMALL Function, with examples that directly apply to your data analysis tasks. By mastering this Function, you'll be able to efficiently handle various data analysis tasks, making it a powerful addition to your Excel toolkit.
Understanding the SMALL Function
The SMALL Function returns the k-th smallest value in a data set. This can be helpful when you need to find the lowest values in a range, such as the bottom three sales amounts or the lowest exam scores. The syntax for the SMALL Function is:
=SMALL(array, k)
- array: The range or array from which you want to find the k-th smallest value.
- k: The smallest position in the array or range of the value to return.
Basic Usage
Example 1: Finding the Smallest Value
Let's say you have a list of sales figures in column A (A2:A10) and you're curious about the smallest sales figure. How would you find it?
1. Select the cell where the result appears (e.g., B2).
2. Enter the formula:
=SMALL(A2:A10, 1)
This will return the smallest value in the range A2:A10.
Example 2: Finding the Second Smallest Value
To find the second smallest value in the same range:
1. Select the cell where the result will appear (e.g., B3).
2. Enter the formula:
=SMALL(A2:A10, 2)
This will return the second smallest value in the range A2:A10.
Practical Applications
Example 3: Bottom N Values
If you need to extract the bottom 3 sales figures from your list:
1. Select the cell where you want the smallest value to appear (e.g., B2).
2. Enter the formula:
=SMALL(A2:A10, 1)
3. In the cell below, enter:
=SMALL(A2:A10, 2)
4. In the next cell, enter:
=SMALL(A2:A10, 3)
This sequence will display the bottom 3 values from the range A2:A10 in cells B2, B3, and B4.
Advanced Usage
Example 4: Conditional SMALL
Use the SMALL Function with the If Function to find the smallest value based on a condition.
1. Assume you have sales figures in A2:A10 and corresponding regions in B2:B10.
2. To find the smallest sales figure for a specific region (e.g., "North"):
=SMALL(IF(B2:B10="North", A2:A10), 1)
This array formula will return the smallest value in the range A2:A10 where the corresponding cell in B2:B10 equals "North".
The SMALL Function in Excel is not just a tool, but a versatile companion for data analysis. It allows users to quickly identify the lowest values within a dataset, regardless of the data type or size. By mastering the SMALL Function, you can efficiently rank data, find bottom performers, and easily make data-driven decisions. Whether you are dealing with financial data, academic scores, or any numerical dataset, the SMALL Function is a powerful addition to your Excel toolkit, empowering you to confidently handle various data analysis tasks.
#ExcelFunction #Small #ExcelTutorial
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Excel Tutorial for Beginners: goo.gl/UDrDcA
Intermediate Excel Tutorial: tinyurl.com/59a837py
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Text Case Conversion Techniques: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
ChatGPT Excel Mastermind: tinyurl.com/46kn7tmd
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG
Website: msexceltutorial.com/