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

For example, you can use SMALL3D to return the smallest, or the 2nd smallest
score in a given range in the whole workbook. You just need to specify a range,
and SMALL3D will go through the same range in all worksheets in the workbook
and find out the answer for you.

Syntax

SMALL3D(range_input, k, include_current)

range_input

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

k

is the position
(from the smallest) 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. Default value
is TRUE.

Remarks

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

If k = 0 or if
k is greater than the number of data points, SMALL3D returns the #NUM! error
value.

If n is the number of data points in a range, then SMALL3D (range_address,1)
returns the largest value, and SMALL3D (range_address,n) returns the smallest
value.