The Kth Smallest Value (SMALL)
Syntax: SMALL(x; k)
The SMALL function returns the kth largest numeric value found in the given set of values x; for example, when given the set of values of 12.55, 10.93, and 11.78, SMALL returns the following result:
=SMALL(B133:D133; 3)
returns 12.55. which is the 3rd smallest value in the given set.
Figure 7-8. Sample result of the SMALL function
You can set the k argument to any integer value you like, but it must not be zero or larger than the number of elements in the given set of numbers.
See also the sections on the LARGE, MAX, and MIN functions.
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
