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
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
Post a Comment