=SMALL(array,k)
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:
Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.
How to use Excel Function PROPER? PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which makes the function…
ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.
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…
COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.
COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2
An Excellent platform to learn EXCEL in easy and Smart way.”Excelsirji…….”amazing!!