Learn How to Use Microsoft Excel LARGE Function

Microsoft Excel LARGE Function

The main purpose of the Microsoft Excel LARGE function is to get the nth largest value. That implies, with the help of the LARGE function you can able to return numeric values based on their position in a list when sorted by value. It can be understood as, it can retrieve "nth largest" values that is - 1st largest value, 2nd largest value, 3rd largest value, etc. So, with the help of the LARGE function, you can able to get the nth largest value in the array.

Return Value of LARGE Function

The return value will be the nth largest value in the array.

Syntax of LARGE Function

=LARGE(array, n)

Where the arguments:

• array: This is the array or range from which you want to get the nth largest value.
• n: This is the integer that specifies the position from the largest value, that is. the nth position.

How to Use Microsoft Excel LARGE Function?

So we know that Microsoft Excel LARGE function you can able to get the nth largest value. That implies, with the help of the LARGE function you can able to return numeric values based on their position in a list when sorted by value. It can be understood as, it can retrieve "nth largest" values that is - 1st largest value, 2nd largest value, 3rd largest value, etc. So, with the help of the LARGE function, you can able to get the nth largest value in the array.

Check out the list of all other articles:

• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel
• Learn How to Sort Birthdays by Month and DAY in Microsoft Excel