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:
Usage:
=LARGE(数组, n)
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:
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!