From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 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

“

- [Instructor] 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, et cetera? 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 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 to look at the values. The top one are 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. I'm going to go back and drag this down.…

Contents