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 duplicates.
0 Comments
Recommended Comments
There are no comments to display.