PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-SMALL

INTRODUCTION

SMALL FUNCTION is one of the very simple but extremely useful function.

It is found under the STATISTICAL GROUP of the formulas in MICROSOFT EXCEL.

SMALL FUNCTION gives us the value of kth smallest number or value i.e. we can find the smallest, second smallest and so on upto kth smallest  number in any given array or range.

 This function is used a lot when we are making report. Whenever we need to find out the smallest number of some range, or second largest or any ranking in a big array, this function is always there for our need.

PURPOSE OF SMALL FUNCTION IN EXCEL

SMALL FUNCTION returns the kth SMALLEST number in a given array or range.

PREREQUISITES TO LEARN SMALL FUNCTION

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the STATISTICAL terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: SMALL FUNCTION

The Syntax for the function is

=SMALL( ARRAY OR RANGE, KTH SMALLEST NUMBER)

ARRAY OR RANGE is the given array or a range in which we want to find out the largest number.
Kth smallest number is the kth smallest number in the given array or range. e.g. 1 for the smallest, 2 for the second smallest and so on.

EXAMPLE:SMALL FUNCTION IN EXCEL

DATA SAMPLE

Let us take a random data to find out the SMALLEST and THIRD SMALLEST in the given data.

DATA  
   
947152359247
841637328216
64867423962
77591948333
72961740161
673910736466
437960573775
802018852948
995735539078
94558959302
6662638070
17902097210
59690273983
53813393976
384411486577
94109522430

We’ll find out the smallest and third smallest number from the above data using the SMALL function.

SMALL FUNCTION IN EXCEL
USING SMALL FUNCTION IN EXCEL

STEPS TO USE SMALL FUNCTION-EXAMPLE

STEPS:

1. Place the cursor in the cell and type the following function

2. USE THE FOLLOWING FUNCTION

=SMALL(C5:E20,1) FOR FINDING THE SMALLEST NUMBER IN THE DATA

3. Again place the cursor in other cell and enter the following function

=SMALL(C5:E20,3) FOR FINDING THE THIRD SMALLEST NUMBER IN THE DATA

2. Press ENTER, the answer will appear as 161 and 210.

The answers can be checked manually. We find that all answers are correct.

 

 

generalized STEPS TO USE COUNTA function

HERE ARE THE STEPS TO USE COUNT FUNCTION
  • USE THE FUNCTION
  • =SMALL(RANGE, KTH SMALLEST NUMBER WE WANT)  in the cell where we want the result.
  • Press ENTER and the result will appear.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]