LARGE function

LARGE(numbers, n) LARGE(numbers; n)

numbers — { Number }

The number array from which the nth largest number is returned.

n — Number or { Number }

The position of the number to return, in a version of the given array sorted in descending order.

Returns — Number or { Number }

The nth largest number in the given array, where n is given as the second parameter.

Returns the nth largest number in the given array, where n is given as the second parameter.

Examples

LARGE({ 22, 5, 3, 14 }, 2)LARGE({ 22; 5; 3; 14 }; 2)

Returns 14, which is the second largest number in the { 22, 5, 3, 14 }{ 22; 5; 3; 14 } array.

INDEX(SORT({ 22, 5, 3, 14 }, SortOrder.Descending), 2)INDEX(SORT({ 22; 5; 3; 14 }; SortOrder,Descending); 2)

Returns 14, which is the second largest number in the { 22, 5, 3, 14 }{ 22; 5; 3; 14 } array. This formula is equivalent to LARGE({ 22, 5, 3, 14 }, 2)LARGE({ 22; 5; 3; 14 }; 2). It first sorts the array in descending order, resulting in the array { 22, 14, 5, 3 }{ 22; 14; 5; 3 }, and then selects the second element of that array.