=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:
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.
In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE
ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.
An Excellent platform to learn EXCEL in easy and Smart way.”Excelsirji…….”amazing!!