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