Jump to content
Business Intelligence & Analytics for Digital Transformation
  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board
  • Excel Tutorials

About this blog

Entries in this blog

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

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 du
×
×
  • Create New...