From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

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

Finding the largest and smallest values with the LARGE and SMALL functions

Finding the largest and smallest values with the LARGE and SMALL functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Finding the largest and smallest values with the LARGE and SMALL functions

- In this worksheet called Large Small, we've got a list of employees and their compensation amounts. We simply want to know, for starters, the highest and the lowest entries. And widely used functions =max. Simply click column B here to find the highest salary, compensation amount, 126. And similarly here, for the minimum min, easy enough. There could be times, however, when you want to know the second highest, third highest, fourth highest, or any number you choose. That function is called large. We're looking in column B, I can either type in the number two, if I see to the right, I can use that cell. First, I'll just type in the two. The second highest compensation amount is this. Not formatted I'll drag the edge with the right mouse button downward to format that. Copy Here's Formats looks like that. And of course, in the example here, I could've used D3 and maybe I do want to get the third, fourth, and fifth highest. So I'll change this to the D3 reference. Complete the entry…

Contents