# How to use LARGE and SMALL Functions in Excel

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

#### 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.

###### 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.