From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

LARGE and SMALL

LARGE and SMALL - Microsoft Excel Tutorial

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 were sold. Mold blue oil, 84 were 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 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. And I'm going to go back…

Contents