SheetFX
≡
<< Go back to all functions

LARGE

The LARGE function in Google Sheets returns the nth largest element from a data set, where n is user-defined. This function is particularly useful when you need to identify the largest values within a range.

Function Syntax and Parameters

Syntax: LARGE(data, n)

Parameters:

  • data: The range or array of values from which you want to find the nth largest element.
  • n: The position of the element you want to retrieve from the data set.

Step-by-Step Tutorial

  1. Using LARGE with a range of cells:
    • Example: If A1:A5 has the values 5, 10, 3, 8, 7, and you want to find the 2nd largest element, use the formula =LARGE(A1:A5, 2).
    • Result: 8

Use Cases and Scenarios

  1. Sales Analysis: Determine the second highest sales figure.
  2. Exam Scores: Find the third highest score in a test.
  3. Sports Rankings: Identify the nth highest ranking in a competition.

Related Functions

  • SMALL: Find the nth smallest element in a range.
  • RANK: Rank a value against a range of values.

Related Articles