Jump to content
Business Intelligence & Analytics for Digital Transformation
  • Excel Tutorials

Calculate Ranks in Excel using RANK.AVG & RANK.EQ function


Saurabh Jain

428 views

 Share

 

Download file 

https://bi-analytics.org/files/file/312-rank-function-in-excel/

 

The Excel RANK.AVG function returns the rank of a number against a list of other other numeric values. When values contain duplicates, the RANK.AVG function will assign an average rank to each set of duplicates.

The Excel RANK.EQ function returns the rank of a number against a list of other other numeric values. When values contain duplicates, RANK.EQ will assign the higher rank to each set of duplicates.

 

 

 Share

0 Comments


Recommended Comments

There are no comments to display.

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board
×
×
  • Create New...