Question: You know how to find the largest value from a given data range by using the maximum function. But how can one find the second largest value from a data range?
Answer: By using the LARGE function
Why: Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score
Syntax: =Large(Array,K)
Array is an array or range of numerical data for which you want to determine the k-th largest value
K is the position (from the largest) in the array or range of data to return
Applies To: Excel 2003, 2007 and 2010
1. To find the second largest value from the following data range;
2. Select cell B19 and type =Large(B2:B17,2)
3. The answer will be $2128.00 meaning the second best sales person is Johnson A
The LARGE function can also be used as an alternative to the MAX function.
If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.
Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations
