Home  >  Article  >  Topics  >  How to use the large function in Excel

How to use the large function in Excel

小老鼠
小老鼠Original
2024-04-17 05:18:13524browse

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)

How to use the large function in Excel

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)
  1. 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:

  • n must be a positive integer.
  • If n exceeds 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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn