Uses of SMALL function in MS Excel

In this tutorial we are going to discuss about SMALL Function.

This article will help you to 

• Understand the Small function.
• Uses and requirements of Small function.
• Syntax of SMALL function.
• Description of small function.

Small Function:-

Formula name  :-    Small
Formula Syntax:-    =SMALL(array, k)

                         Array (Required) An array is a range of numerical data for which you want to                         determine the k-th smallest value. 

                         K (Required)  numerical value position (from the smallest) in the range of data                       to return.

Uses of SMALL Function:- this formula is basically uses to determine the #number of smallest number from a data set. 

see the video example below:

Please right your questions in to comment box.


Happy learning
Vikash kumar