Ranking duplicates the different rank in Excel

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


Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

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