Administration and Executive AssistantTier 430 minintermediate

SORT and SORTBY Wrapped in INDEX

Pull out the top result by the measure that actually matters, not the one that is easiest to sort by eye.

What you will learn

• Explain the difference between ranking by a raw figure and ranking by a derived one
• Use INDEX/MATCH against MAX() to pull the top row by a calculated measure
• Recognise SORT() and SORTBY() as array functions that need wrapping to read their result from one cell

Excel skills

SORT, SORTBY, INDEX, MATCH, MAX · Dynamic Arrays

The task

I need the name of our top sales rep this month for the newsletter. "Top" means highest sales after returns are taken off - net, not gross. Someone with huge sales and huge returns has not actually earned the business that much.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free