This page isn't translated yet, so its text is in English. Function names and formulas are shown in your Excel language.
Excel function · Statistics
GRANDE.VALEUR(LARGE)
Returns the k-th largest number, such as the second highest.
What it does
LARGE returns the value at a given place when the numbers are ordered from largest down: k = 1 is the maximum, k = 2 the second highest, and so on. It is useful for top-3 lists.
Syntax
=GRANDE.VALEUR(array; k)Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;
Arguments
- array
- The numbers to rank.
- k
- Which place to return, counting from 1 for the largest.
Example
What is the second-best score?
| A | B | C | |
|---|---|---|---|
| 1 | Score | Second highest | |
| 2 | 64 | 88 | |
| 3 | 88 | ||
| 4 | 75 | ||
| 5 | 92 | ||
| 6 | 81 |
The formula in C2:
=GRANDE.VALEUR(A2:A6;2)Result: 88
Ordered from the top, the scores are 92, 88, 81, 75, 64. The second one is 88.
Common mistakes
- Asking for a k larger than the number of values, which gives
#NUM!. - Expecting ties to be skipped. If two people score 92, both the 1st and 2nd largest are 92.
In other Excel languages
Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.
| Excel language | Function name | Separator |
|---|---|---|
| English | LARGE | , |
| Deutsch | KGRÖSSTE | ; |
| Français | GRANDE.VALEUR | ; |
| Español (España) | K.ESIMO.MAYOR | ; |
| Español (México) | K.ESIMO.MAYOR | , |
| 日本語 | LARGE | , |
| 한국어 | LARGE | , |
| 繁體中文 | LARGE | , |
| ไทย | LARGE | , |
| ខ្មែរ | LARGE | , |
| Tiếng Việt | LARGE | ; |