Excel 2007 -How to get the smallest value from a set of values without sorting out the data.
In the previous post, i have show how to use “SUMIF” function. I will continue use the table from previous post to show how to use SMALL function in Microsoft Excel 2007.
Normally, we are using “SORT” function to get the smallest or largest records. However, by using “SMALL” function, we do not need to do it so.
The “SMALL” function in Microsoft Excel returns the smallest value from a range of values. You can also use it to return other values in relation to the smallest value. This function can be quite useful when you are looking to quickly find a low value in a large range of numbers.
The syntax for the Small function is:
Small( array, K)
array is an array or range of numerical data for which you want to determine the k-th smallest value.
K is the position (from the smallest) in the array or range of data to return.
Remarks
If array is empty, SMALL returns the #NUM! error value.
Example: use the table from previous post
Result:-
Comments
Leave a Reply
