The Kth Largest Value (LARGE)
Syntax: LARGE(x; k)
The LARGE 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, LARGE returns the following result:
=LARGE(B128:D128; 3)
returns 10.93, which is the 3rd largest value in the given set.
Figure 7-7. Sample result of the LARGE 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 SMALL, 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.
