EXCEL FUNCTION – SMALL

Excel Function SMALL

SMALL function is used to get the Smallest k-th value from the range.

SMALL Function has two required arguments i.e. array, and k

Syntax:

=SMALL(array,k)

Syntax Description:

array argument is used to give the range from which smallest value is required

k argument is used to give value for th value i.e. 1^st , 2^nd ,3^rd, 4^th … position from the array argument

Example 1:Excel Function SMALL with cell Range:

“Column A” has number values,
“Column B” shows the sample formula applied,
“Column C” shows the value for k argument (position), k-th position that is required,
“Column D” shows the output of the function and,
Explanation is provided in “Column E”

Usage Notes

The SMALL function returns a numeric value based on its position in a list when sorted by value in ascending order. In other words, SMALL can return the “nth smallest” value (1st smallest value, 2nd smallest value, 3rd smallest value, etc.) from a set of numeric data.

The SMALL function takes two arguments, array and k. An array is an array or range of numeric values.

To get nth largest values, see the LARGE function.

Recommended Articles

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:

Excel Functions

Excel Function – WEEKNUM Function

Byexcelsirji

https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…

Excel Functions

EXCEL FUNCTION – AVERAGE

ByPradeep Kumar

AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.

Excel Functions

Excel IMAGE function – quick way to insert picture in cell with formula

BySumit Shrimal

Learn an easy way to add pictures directly into a cell using the new IMAGE function! For a long time, adding pictures to Excel was tricky and time-consuming. But now, with the IMAGE function, you…

Excel Functions

How to find Median in Excel

BySumit Shrimal

Understand how to find median in Excel with simple steps. Understanding the middle value in a set of numbers, known as the median, is important in the data industry. Professionals often use Microsoft Excel to calculate this. Excel’s MEDIAN function helps quickly find this value from long lists of numbers. This saves time and allows for further calculations using the median value. In this article, we explain what the MEDIAN function in Excel does, why it’s useful, and two methods to find the median in your data.