EXCEL FUNCTION – SMALL

EXCEL FUNCTION – SMALL

How to use “SMALL” function in Excel

SMALL function is used to get the Smallest k-th value from the range.

SMALL Function has two required arguments i.e. array, and k

Syntax:
=SMALL(array,k)
Syntax Description:

array argument is used to give the range from which smallest value is required

k argument is used to give value for th value i.e. 1st , 2nd ,3rd, 4th … position from the array argument

Example 1: SMALL function with cell Range:
  • “Column A” has number values,
  • “Column B” shows the sample formula applied,
  • “Column C” shows the value for k argument (position),  k-th position that is required,
  • “Column D” shows the output of the function and,
  • Explanation is provided in “Column E”
SMALL Function Excel Tutorial

Hope you learnt this Function,

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:

Comments
  • Anshu Taneja says:

    An Excellent platform to learn EXCEL in easy and Smart way.”Excelsirji…….”amazing!!

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs

Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business