LARGE

Syntax:

LARGE ( array , k )

Description: Computes the kth largest value in a data set.

Arguments:

Name

Type

Description

array

array, reference

The set of numbers from which the kth-largest value is to be determined.

k

number

The position (from the largest) in the array or cell range of data to return.

Return Type and Value: number – The kth largest value in a data set.

However, if

  • array is empty, the return value is unspecified.

  • k ≤ 0, #NUM! is returned.

  • k is greater than the number of data points, #NUM! is returned.

example: