=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.
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
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 Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
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
FIND function is used to find the position of text, or character in an available string.
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.
An Excellent platform to learn EXCEL in easy and Smart way.”Excelsirji…….”amazing!!