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.

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

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.