SMALLFunction in Excel: Extracting the Smallest Values in Your Data

28 Feb, 2023
Paresh @Boloforms
1 min read
Use AI to answer all your Excel & Google Sheets related queries. Try SheetGod for free now.
Try now!

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.