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