How to use LARGE and SMALL Functions in Excel

Excel Large and Small Function Tutorial

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 1^st 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 1^st 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.

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

2^nd k (Compulsory Argument) under this we need to give the 1 or 6 or 10^t 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 6^th 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.