Microsoft Excel: MIN, MAX vs SMALL, LARGE functions

MIN() & MAX()

As we already know MIN() and MAX() functions gives the minimum or maximum number from a given range.

Basic Syntax:

=MIN(range)

=MAX(range)

Let’s apply this for a practical use case:

Suppose we have the following data.

Applying min and max gives us the above result. MIN() function returns the smallest value among the range and MAX() function returns the greatest number within the range.

Suppose you wanted to extract the second smallest number or the third largest number.

Using MIN and MAX you couldn’t find out these values.

To find out values like the second smallest number or the third largest number we can use the small and large functions. These functions can even be used in place of min and max to find out the absolute minimum and absolute largest. 

Let’s find out how.

SMALL() AND LARGE() functions in excel

Basic Syntax:

=SMALL(range, nth position)

=LARGE(range, nth position)

This function takes 2 arguments, first is the range and second is the position.

Let’s implement the above in MS-Excel

You can clearly notice from our above data set that we have successfully managed to print the second smallest number and the third largest number using small and large functions.

To make small and large behave like min and max, just make the second argument to the function as 1.

Like this:

Notice, now both the functions are giving the same result.

Hope you have found this article to be useful.Stay tuned to receive more such MS-Excel materials.

Are you looking for a full fledged training? You are at the right place.

At TechnoExcel :

You can upskill yourself with:

Why us?

Techno Excel is a leading provider of Excel courses and data analytics courses. We not only teach you how to use excel but also help customize it for your exact needs! Make the most out of your career with Techno Excel. Students can join via classroom course or via Online course. This is the place where students can easily learn the required skill set to get placed immediately

Learn data science and other technologies at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace. Whether you are a beginner or a professional looking for advanced techniques, we have the right course for you. Hurry up!! Book your seat now!!!

Class-room of your choice

Upskill yourself by attending classroom or online class.

Flexible timings

Learn at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace.

Class-Room Size

With limited students in class, attention to each student's performance will be given.

Industry Ready Curriculum

The course is designed for people who want to work in the industry.

Book your free consultation now

If you want to improve your skills and get ready for the workforce! Please enter your information below, and one of our expertise will contact you shortly.

    Leave a Comment

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