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

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