Returns the k-th
largest value in a given range in all worksheets in a workbook.

For example, you
can use LARGE3D to return the highest, runner-up, or third-place score in a
given range in the whole workbook. You just need to specify a range, and LARGE3D
will go through the same range in all worksheets in the workbook and find out
the answer for you.

LARGE3D is very
similar to the LARGE function of Microsoft Excel. The main difference is that
LARGE3D considers all worksheets, while the original LARGE function doesn't.

Syntax

LARGE3D(range_input,
k, include_current)

range_input
- is the range for which you want to determine the k-th largest value.

k - is
the position (from the largest) in the array or cell range of data to return.

include_current
- Optional. Boolean argument , either TRUE or FALSE. Decides whether the current
worksheet is included in the function's consideration. TRUE means the current
worksheet will be considered, and vice versa.

Remarks

If array is
empty, LARGE3D returns the #NUM! error value.

If k = 0 or
if k is greater than the number of data points, LARGE3D returns the #NUM!
error value. If n is the number of data points in a range, then LARGE3D(range_address,1)
returns the largest value, and LARGE3D(range_address,n) returns the smallest
value.