PrecisionCalc
xl
Precision

xlpLARGE

Returns the k-th largest number in a cell range, with up to 32,767 significant digits of precision. Same as Excel's built-in LARGE function, but with high precision.

Syntax

xlpLARGE(numlist,k)

 numlist Required. The array or range of cells with the numbers to sort. k Required. The position (from the largest) in the cell range to return.

Remarks

• numlist can accept cells with both numbers and text.

• numlist can accept cells with text formatted with the local currency symbol and thousands separators, and negatives can be formatted with either a leading hyphen or parentheses.

• The return value will be formatted however the chosen input is formatted. To specify number formatting to apply to the return value, xlpLARGE can be formatted by wrapping it in other xlPrecision functions such as xlpADD. See example below.

Examples

Formula Description Result
=xlpLARGE(A1:C5,3)

 A B C 1 10 20 70 2 120 30 110 3 90 60 ABC 4 40 150 5 80 140 100
The 3rd-largest number in A1:C5. 120

 A B C 1 10000 20000 70000 2 120000 30000 110000 3 90000 60000 ABC 4 40000 150000 5 80000 140000 100000
The 3rd-largest number in A1:C5, formatted with thousands separators by wrapping xlpLARGE in xlpADD (adding the result of xlpLARGE to 0 to get the same result) and specifying thousands separators in xlpADD. 120,000
=xlpLARGE(A1:A17,13)

 A 1 100000000000000000000.1 2 1000000000000000000000.1 3 10000000000000000000000.1 4 100000000000000000000.01 5 1000000000000000000000.01 6 100000000000000000000.001 7 1000000000000000000000.001 8 100000000000000000000.0001 9 1000000000000000000000.0001 10 \$1,000 11 \$1,234,567,890,123,456,789.012345 12 1234567890123456789.012345 13 5 14 \$100000000000000000000 15 \$1000 16 1,234,567,890,123,456,789.012345 17 1.00000000000000000000000000001
The 13th-largest number in A1:A17. 1,234,567,890,123,456,789.012345