Ranking duplicates the different rank in Excel


Excel Course : The Ultimate Excel Programmer Course

Situation

How to rank duplicates the different rank in Excel ?

Example

For descending (decreasing) order :

In cell D3, type the following formula

=RANK(C3,$C$3:$C$10,0)+COUNTIF(C3:$C$10,C3)-1

For ascending (increasing) order :

In cell E3, type the following formula

=RANK(C3,$C$3:$C$10,1)+COUNTIF(C3:$C$10,C3)-1

Coursera Data Science

Excel Tutorials : 100 Excel Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

0 Response to "Ranking duplicates the different rank in Excel"

Post a Comment

Next → ← Prev