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
=SMALL(array,k)
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. 1st , 2nd ,3rd, 4th … position from the array argument
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.
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:
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
COUNT function is used to get the total count of Number values in range or list.COUNT Function has one required and optional arguments.
An Excellent platform to learn EXCEL in easy and Smart way.”Excelsirji…….”amazing!!