How to use LARGE and SMALL Functions in Excel

Last modified date

Click here to download the excel file which contains the below examples

How to use LARGE and SMALL Formulas in EXCEL
How to use LARGE and SMALL functions in Excel

Description of LARGE and SMALL Functions

LARGE Function: This function will give the Largest number in the selected range and also we have an option to get the 1st Largest number, 2nd Largest Number and so on as per requirement.

SMALL Function: This function will get the Smallest number in the selected range and also we have an option to get the 1st Smallest number, 2nd Smallest Number and so on as per requirement.

Syntax of LARGE and SMALL Functions

LARGE(array,k)
SMALL(array,k)

Arguments of LARGE and SMALL Functions

Total 2 Arguments and usage is also same for both functions.

1st Array (Compulsory Argument) under this we need to give the range of cells where we have the data.

2nd k (Compulsory Argument) under this we need to give the 1 or 6 or 10t as per requirement Largest or Smallest number should be updated.

Explanation of LARGE and SMALL Functions

LARGE FUNCTION

LARGE Formula used in G8 =LARGE($E$6:$E$18,H8)

Result is 254

It means 6th Largest number in the selected range is 254.

Like this, we can give 1st, 3rd, 4th, 5th, and so, on as per our requirement, the highest number we can give is the count of the numbers in the selected range.

How to use Large function in Excel
LARGE FUNCTION Example
SMALL FUNCTION

SMALL Formula used in G28 =SMALL($E$26:$E$38,H28)

Result is 159

It means the 6th Smallest number in the selected range is 159.

Like this, we can give 1st, 3rd, 4th, 5th, and so, on as per our requirement, the highest number we can give is the count of the numbers in the selected range.

How to use SMALL Function Example
SMALL Function Example

Leave a Reply

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

Post comment