Excel LARGE Function
The Excel LARGE function returns numeric values based on their position in a list when sorted by value. In other words, it can retrive "nth largest" values - largest value, 2nd largest value, 3rd lagest value, etc.
- array - The array from which you want to select the kth largest value.
- n - An integer that specifies the position from the largest value, i.e. the nth position.
The LARGE function is useful when you want to retrieve the nth highest value from a set of data — for example, the first, second, or third highest scores for a test. Like the SMALL function, the LARGE function retrieves numeric values based on their position in a list when sorted by value.
Note: Microsoft documentation refers to "k" instead of "n". We use n because "nth" is much easier to say.