Google Sheets LARGE SMALL Functions: How to Find the Nth Value
Beyond First and Last Place The MIN and MAX functions are great for finding the absolute lowest and highest values in a dataset. But what happens when you need more nuance? How do you find the second-highest sales figure, the third-fastest race time, or the fifth-lowest test score? For this level of statistical detail, you need the Google Sheets LARGE SMALL functions . This powerful duo allows you to pinpoint a value based on its rank within a dataset, not just its extreme position. They are essential tools for anyone who needs to perform ranked analysis, from teachers creating grade curves to analysts identifying top performers. The LARGE Function: Finding Top Values The LARGE function scans a range of data and returns the Nth largest value. If you want the top score, it's the 1st largest. If you want the runner-up, it's the 2nd largest, and so on. This gives you far more granular control than the MAX function. LARGE Function Syntax The formula is simple and requires j...