What is LARGE?
Returns the k-th largest value in a dataset. Perfect for finding top performers, second highest, third place, etc.
Syntax
=LARGE(array, k)
Example
Formula: =LARGE(A1:A10, 2)
Result: Second highest value
How It Works
Returns the 2nd largest value in the range. LARGE(range, 1) equals MAX. Use for ranking, top-N analysis, and percentile calculations.