How to use the RANK function in excel: 2 ways of using it || Datawitzz

How to use the RANK function in excel

Excel rank function helps in comparing a particular value among all values available in the range. This is very useful when we have performance of employees available in a column and we we wanted to show position of that employee among all employees in that department especially when we don’t want to sort the performance of employees.

There are two rank formula in excel available. First Rank.AVG and second Rank.EQ. Both these rank formula provides ranking, just the difference is when a duplicate entry comes RANK.AVG provides average ranking while RANK.EQ returns the higher rank number of that set of values.

Let us first understand how the syntax of excel rank function … Continue Reading