LARGE function

Category: Statistical functions

 

What does this function do?

Returns the largest k-th value of a data set.

Syntax:

LARGE (array,k)

• Array (required): the array or range of data for which you want to determine the k-th largest value.
• K (required): the position (from the largest) in the array or cell range of data to return.

Examples:

=LARGE({1,2,5,3,6}, 4)= 2

If A1:A5={1,2,5,3,6}

=LARGE({A1:A5, 4)= 2