Skip to content

Functions Both Large and Small

This article is all about the LARGE and SMALL functions!

These functions are designed to help you find the k-th largest or smallest value in a dataset. It means the 1st, 2nd, 3rd, etc., largest or smallest value.

It’s also important to note that both of these functions are available in Microsoft Excel and Google Sheets.

The LARGE Function

The LARGE function returns the k-th largest value in a dataset.

In other words, it returns the 1st, 2nd, or whatever number you specify, largest number in a dataset.

It is referred to as k-th because k is the value you specify to indicate if you are looking for the 1st, 2nd, 3rd, or whatever largest value.

For example, if you pick k to be 5, the LARGE function will find the 5th largest number in the dataset.

How to Use the LARGE Function

The LARGE function accepts two arguments.

They are:

  • Array – The range of cells containing the numbers you want the function to look through
  • K – This is a number that indicates if you’re looking for the 1st, 2nd, 3rd, etc., largest number

Take a look at the following example.

The LARGE function is set up to look through the list of numbers in A2:A6 and find the 2nd largest number.

The function does its thing and returns the number 40 because this is the 2nd largest number in the dataset.

The SMALL Function

The SMALL function works just like the LARGE function but returns the k-th smallest value in a dataset.

For example, if you pick k to be 3, the SMALL function will find the 3rd smallest number in the dataset.

How to Use the SMALL Function

The SMALL function accepts two arguments.

They are:

  • Array – The range of cells containing the numbers you want the function to look through
  • K – This is a number that indicates if you’re looking for the 1st, 2nd, 3rd, etc., smallest number

Take a look at the following example.

The SMALL function is set up to look through the list of numbers in A2:A6 and find the 2nd smallest number.

The function does its thing and returns the number 20 because this is the 2nd smallest number in the dataset.

And that is how you can use either the SMALL or LARGE functions to find the k-th smallest or largest numbers in your dataset.

This Post Has One Comment

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top