How to use the large function in Excel

Excel's LARGE function can return the Nth element specified from largest to smallest in the number list: Syntax: LARGER (array, n) Parameters: array (number list), n (the element to be found, from largest to smallest) to the Nth smallest) Usage: Select the cell where you want to place the result and enter the formula =LARGE(array, n)

LARGE in Excel Function

The LARGE function can return the specified Nth element from largest to smallest in a list of numbers.

Syntax:

LARGE(数组, n)

Parameters:

• Array:Contains the element to be found list of numbers.
• n:The element to be found, the Nth from largest to smallest.

Usage:

1. Select the cell where you want to place the result.
2. Enter the following formula:

=LARGE(数组, n)

3. Press the Enter key.

Example:

Suppose you have a list of numbers A1:A10, and you need to find the fifth element from largest to smallest.

In cell E1, enter the following formula:

=LARGE(A1:A10, 5)

Press the Enter key, and cell E1 will display the result.

Note:

• nmust be a positive integer.
• Ifnexceeds the length of the array, the function will return a #NUM! error.
• The LARGE function sorts numbers, so the order of the array may change.
• For repeated values, the function will return the first occurrence of the element.

The above is the detailed content of How to use the large function in Excel. For more information, please follow other related articles on the PHP Chinese website!