The Sundarban
Revealed Apr 19, 2026, 12:30 PM EDT
Tony Phillips is an experienced Microsoft Administrative heart user with a twin-honors level in Linguistics and Hispanic Studies. Prior to starting with How-to Geek in January 2024, he labored as a sage producer, information supervisor, and insist creator for over ten years, and loves making spreadsheets and documents in his spare time.
Tony is moreover an tutorial proofreader, experienced in reading, editing, and formatting over 3 million phrases of non-public statements, resumes, reference letters, be taught proposals, and dissertations. Sooner than joining How-To Geek, Tony formatted and wrote documents for upright corporations, including contracts, Wills, and Powers of Attorney.
Tony is smitten by Microsoft Administrative heart! He’ll find any cause to invent a spreadsheet, exploring ways to add complex formulas and ogle original ways to originate information tick. He moreover takes satisfaction in producing Note documents that stare the share. He has labored as a information supervisor in a secondary college in the UK and has years of ride in the be taught room with Microsoft PowerPoint. He loves to stumble upon concerns in Microsoft Administrative heart and use his ride and upright-level training to find solutions.
Exterior of the Microsoft world, Tony is a interested dog owner and lover, soccer fan, astrophotographer, gardener, and golfer.
Manually re-sorting your Excel tables at any time when a rating modifications is a waste of time. The RANK.EQ function automates leaderboards by assigning positions instantly. Whether you is likely to be tracking sales or fling instances, right here is how to protect your information dynamic and upright.
Beforehand, RANK used to be Excel’s finest ranking function. Nonetheless, in 2010, Microsoft introduced RANK.EQ (the same to the aged RANK) and RANK.AVG (a original option that returns the moderate outrageous for ties). In this handbook, I will use RANK.EQ, since or no longer it’s the contemporary customary and works in exactly the same procedure as RANK.
Understanding the syntax
The RANK.EQ function identifies the place a host sits relative to others in a listing, providing a “live” standing that updates automatically. The function follows a straightforward syntax:
=RANK.EQ(number, ref, [order])
the place:
number (required) is the fee you wish to possess to outrageous.
ref (required) is the differ or array of numbers you is likely to be comparing the fee against. Non-numeric values (like textual insist or blanks) are passed over.
expose (optional) determines the ranking route. Use 0 (or poke away it blank) for a descending outrageous, or 1 for an ascending outrageous.
If more than one values possess the same outrageous, RANK.EQ assigns them the top outrageous of that community. For instance, if two of us tie for the perfect rating, they both receive a outrageous of 1, and the subsequent perfect rating receives a outrageous of 3.
The RANK function works most efficient with Excel tables because they address differ growth and structured references automatically. Nonetheless, in case you must use a ordinary cell differ, lock your ref using greenback indicators—corresponding to $B$2:$B$10.
To note alongside as you be taught, obtain a free reproduction of the Excel workbook used in the examples. After you click on the link, that you would be able to presumably find the obtain button in the top-sincere nook of your masks, and in case you begin the file, that you would be able to presumably be in a place to accumulate admission to each and each use case on a separate worksheet tab.
Use case 1: Building a dynamic leaderboard
Irascible entries with out reordering rows
RANK.EQ identifies top performers whereas keeping your information in its original expose.
The wretchedness: You’re going to possess an Excel table named T_Sales. It includes an ID column representing the expose in which basic points had been signed. You desire the outrageous in column A so the standings are visible, nonetheless you have to protect the table sorted by ID to match your bodily receipts.
To generate these standings, model this components into cell A2 and press Enter:
=RANK.EQ([@Revenue], [Revenue], 0)
Here’s how the components works:
- [@Revenue] appears at the income for the fresh row. For ID 101, it sees 52000.
- [Revenue] compares that fee against every number in the complete column.
0 ensures the person with the perfect income (Elena) is assigned outrageous 1. You presumably can poke away this out for a cleaner components.
Why no longer sincere use table sorting?
Or no longer it’s tempting sincere to model from largest to smallest using the filter arrow at the top of the Revenue column. Nonetheless, as effectively as messing up your original ID expose, or no longer it’s miles a static fix for a dynamic speak. As soon as you add a original sale or replace a income determine, that you would be able to presumably possibly presumably want to reapply or maintain the model.
By using RANK.EQ, you invent a “set it and forget it” machine. It enables you to protect your main table in its original expose, and the components expands downward to any original rows you add, meaning the rankings replace instantly.
Gain the most of your information
To originate the consequence some distance more meaningful, use the outrageous in column A as the engine for a SORTBY components to automatically indicate your information from outrageous 1 downward.
In a blank cell, model:
=SORTBY(T_Sales, T_Sales[Rank], 1)
This creates a dynamic reproduction of your table that stays ordered from 1 to 5. Even even supposing your source table remains sorted by ID, this original checklist ensures that outrageous 1 continuously sits at the top. As soon as the information modifications, this checklist updates automatically.
Use case 2: Ranking fastest instances
Tackle eventualities the place the lowest number wins
By flipping the expose argument of the RANK.EQ function, that you would be able to presumably be in a place to originate determined that the smallest numbers are diagnosed as the “winners.”
The wretchedness: You is likely to be tracking lap instances in a table named T_Results. You want to protect this table in its original expose of the starting grid (StartPos), nonetheless you aloof desire to know who at the 2d holds the fastest lap.
