Best Online Learning Platform and Collect Information

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


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


Follow by Email

Popular Posts