LARGE (PQL - xl)

This function returns the nth largest value in a data set, where n is specified

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

LARGE(array, k)

Function Arguments

Name

Description

Type

Optional

array

Array from which to return the nth largest value

StringOrNumber

k

The position (from the largest value) for which to return the value (for example, 5 to return the fifth largest value). Must be equal to or less than the number of items in the array

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'LARGE' function - using the same inputs, logic and outputs.