Discover how to use the SMALL function in Excel to quickly extract the smallest values from your data. Learn the syntax, how to use it with arrays, and how to use it with ranges of cells. A beginner’s guide to mastering the powerful tool of the SMALL function in Excel.

Start taking digital signatures with BoloSign and save money.

The SMALL Function in Excel is a highly useful function that allows you to quickly and easily extract the smallest values from your data. This function takes two arguments — an array and a k-value — and returns the k th smallest value from the given array.

For example, let's say we have a list of numbers: 8, 9, 5, 2, 6, 10. To find the second smallest number in this list, we would use the SMALL function with the following syntax: =SMALL(array,2). In this case, the array is our list of numbers, and the k-value is 2, meaning that the function will return the second smallest number from the array.

Therefore, the result of our formula would be 6, as it is the second smallest number in the list. The SMALL function can be used similarly to find any number in the list, as long as you specify the correct k-value. You can also use the SMALL function with ranges of cells in Excel. For example, if you had a range of cells containing numbers, you could use the following syntax to find the third smallest number in the range: =SMALL(range,3).

In conclusion, the SMALL function in Excel is a simple but powerful tool that can be used to quickly extract the smallest values from a given array or range of cells. With just a few simple arguments, you can easily find the kth smallest value in your data.

Co-Founder, BoloForms

28 Feb, 2023

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.