A teammate ranked 10 sales reps by revenue using the pre-365 idiom: an INDEX/MATCH/LARGE chain dragged ten times for the names, plus a separate LARGE column for the revenue values. Two columns, twenty cells of brittle formula.
The modern equivalent is one cell: SORTBY sorts a range by a key range, with sign on the third argument controlling direction (-1 = descending).
Columns A–B contain RepName and Revenue. The pre-laid-out output area:
- D1 = SortedRep header
- E1 = SortedRevenue header
- D2:E11 is empty — for the spill output
Your task:
- In D2, write a single SORTBY formula that returns the entire
A2:B11 range, sorted by B2:B11 descending. The result spills as a 10×2 block into D2:E11 — don't drag.
Graded cells: D2 (=Davis, top rep), D5 (=Jones, 4th by revenue), E2 (=90000, top revenue).
Open this problem on a desktop to attempt it.