LARGE function

This topic describes the formula syntax and usage of the LARGE function in the Data Quality Execute Formula transform.

Description

Returns the k-th largest value in a data set. If n is the number of columns in a range, LARGE(range,1) returns the largest value and LARGE(range,n) returns the smallest value in a row.

Syntax

LARGE(range,k)

The LARGE function has the following arguments.

  • range Required. Range of columns in the format [firstcolumn]:[lastcolumn].
  • k Required. The position (from the largest) in the array or cell range of data to return.

Notes

  • If range is empty, LARGE returns the #NUM! error value 6.
  • If k ≤ 0 or if k is greater than the number of data points in a range, then large returns the #NUM! error value 6.

Example

Table 1. Data
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10
1 2 3 4 5 6 7 8 9 10
100 90 80 70 60 50 40 30 20 10
Table 2. Formula
Formula Description Result
LARGE([c1]:[c10],3) Third largest value in a row. 8 and 80
LARGE([c1]:[c10],7) Seventh largest value in a row. 4 and 40