How to use the RANK function in Excel? (Both RANK.AVG and RANK.EQ explained)

Excel's RANK function has been superseded by RANK.AVG and RANK.EQ functions.

These functions help you rank your data and also determine the ranking mechanism in case of tied values.

The earlier Rank function did not provide the flexibility to determine the behaviour in case of ties, but these two new functions help you control that.

In this video, we will discuss both RANK.AVG and RANK.EQ, so that you can confidently and accurately rank your data with precision.

🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introductions
00:55 - Understanding RANK.AVG
02:26 - Understanding RANK.EQ
03:36 - Ranking data in descending order

✅ Subscribe to our Channel to level up your Excel skills faster

⬇️ Download the file used in the video

💻 Courses offered by us

Learn more about our Excel Masterclass course

Explore all courses

📘 Download our E-Book on Excel Shortcuts (Windows and Mac)

🗂️ Access all our templates and E-Books

🤝 Connect with us

#analyticssuccess