From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Find the nth largest or smallest value

Find the nth largest or smallest value - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Find the nth largest or smallest value

“

- [Instructor] Business questions often revolve around identifying high or low values. For example, how much you make from your third largest customer or the second shortest delivery time for a shipment. In this movie, I will show you how to identify those types of values in a dataset. This worksheet contains a column of sales values in column A and what I'd like to do is find the third largest value and the second smallest value. To do that, I can use the large and small functions. For the third largest value, I'll click in cell D2, type an equals sign and then use the function large, l-a-r-g-e, left parentheses. Now I need to identify my data range and then the number of the item I want to identify. So I'll click cells A2 through A12 to select them, then a comma. I'm looking for the third largest, so I'll type three, right parentheses and enter, and I get the value of 7,460. So I have 7,478, 7,465 and 7,460 is my third largest value. So that's correct. Now let's do the same thing…

Contents