FinanceTier 612 minintermediate

Rank Sales Reps by Commission Earned

Rank every rep from highest commission to lowest, reading correctly regardless of row order.

What you will learn

• Use RANK.EQ with the correct direction argument for a highest-first leaderboard
• Explain why RANK.EQ's default direction argument flips a leaderboard's meaning if set wrong
• Recognise rank as independent of the order rows happen to be listed in

Excel skills

RANK.EQ · Statistical Functions

The task

Eight reps' commissions are listed. Rank every rep in column C so the highest commission is rank 1, the way a leaderboard should read.

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