Level 3Formulas That SpillPractice, 2 min

SORT, biggest first

The task

In D2, sort the rep table by Revenue, highest first. SORT takes the range, the column number to sort by, and TRUE for ascending or FALSE for descending.

The data

The starting sheet. Cells outlined in green are where your formulas go.

ABCDE
1RepRevenueRepRevenue
2Maya$48,200
3Theo$39,100
4Priya$52,700
5Jonah$31,800
6Lena$44,600
7Omar$27,300

See all lessons