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.
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.
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.