How to Rank Data in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to rank data in Excel using the RANK.EQ formula.

Quick summary

The RANK.EQ function in Microsoft Excel lets you instantly rank data within a range in either ascending or descending order. This step-by-step walkthrough shows you exactly how to access and configure the formula using Excel's built-in Formulas menu.

Steps

Select a cell under the column you wish to use for ranking.
Go to the top menu bar and click Formulas.
Find and select More Functions from the Formulas menu.
Hover over the Statistical option and choose Rank.EQ.
Click the Number input field and enter the cell reference containing the data you wish to rank.
Click the REF input field and specify the cell range to use for ranking.
Enter "0" in the Order field for descending order, or "1" for ascending order.
Click Insert to run the formula and apply the ranking.
Your selected Excel data will now be ranked based on your input.

📌 Why this matters

Ranking data in Microsoft Excel is a critical skill for analysts, managers, and students who need to compare values across datasets quickly and accurately. The RANK.EQ function provides a reliable, built-in method to assign numerical rankings to data without manual sorting, saving time and reducing errors. Whether you are ranking sales figures, scores, or performance metrics, mastering this Excel formula enables faster, data-driven decision-making. This interactive demo makes the process easy to follow, guiding users through every step from selecting a cell to inserting the final formula.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel