Using Excel's LARGE Function
If you're familiar with Excel's
The simple LARGE function
The syntax for the
LARGE( range, k)
Given these inputs,
Let's look at a simple example of
LARGE( C3:C6, 2)
The above function outputs
Let's try another example; say that this time, SnackWorld wants to find the third-best performing category. To modify our sheet, we just need to change the
LARGE( C3:C6, 3)
This formula outputs
Using LARGE with INDEX MATCH
Of course, SnackWorld probably wants to know the name of these categories, not just the dollar sales. To get category names as well as dollar sales values, we can combine the
INDEX( B3:B6, MATCH( F2, C3:C6, 0))
If you aren't familiar with
Now you know how to use
Save an hour of work a day with these 5 advanced Excel tricks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on getting Excel to do your work for you.
- How to create beautiful table formatting instantly...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...