Administration and Executive AssistantTier 625 minintermediate

Ranking with RANK.EQ

Rank a leaderboard so the highest score comes first, using RANK.EQ's direction argument correctly.

What you will learn

• Use RANK.EQ to rank values with the highest value as rank 1
• Explain what the order argument controls, and why 0 (or omitting it) ranks highest-first
• Recognise that setting order to 1 inverts every rank, not just some of them

Excel skills

RANK.EQ · Ranking and Ordering

The task

Eight players' scores are listed. Rank every player in column C so the highest score 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