Uses of SMALL function in MS Excel

Vikash Kumar

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 Comments

  1. juanjuergensMay 16, 2017 at 1:50 PM

    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

    ReplyDelete