From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

LARGE and SMALL

LARGE and SMALL

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

LARGE and SMALL

“

In Excel, there is max and min to give you the max number or the minimum number in an array. But what happens if you don't want just the top one or the bottom one, but you'd like the second value, the fifth value, etc. That's what we're going to do here. We're going to do large and small. We've got data about these different colors and the various media. So we've got a column for gel. So eggshell, gel, 30 was sold. Mold blue, oil, 84 was sold. Now we just need some quick analysis. We don't care about the colors. We just want look at the values. The top one or the max equals large. Double-click. What array? And notice we don't have a single column or a single row. We really have an array. So, I'm going to highlight here and then F4 for the absolute reference, comma, K. That's the number that I want from the array. I want the largest one. Enter. 84. Now I'm going to go back and drag this down. And notice we have two 84s in our data set. And large is showing 84 as both the first and…

Contents