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

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

Related Posts:
0 Response to "Ranking duplicates the different rank in Excel"

Post a Comment

We have Zero Tolerance to Spam. Comments with links will be deleted immediately upon our review.

Next → ← Prev
Love this Post? Spread the Word!
Share