### 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

Share:

#### 1 comment:

1. Thanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks, I’ll probably keep it short and sweet and link to this instead if thats cool. Thanks.
excel vba training london