issue with Rank formula with duplicate ranks

[lokeshsu]

Hi all,

i am using a rank formula to calculate the rank and i have multiple same values so i am using the below formula

=IF(COUNTIF($A4:K4,K4)=1,RANK(K4,$A4:$Y4,1),RANK(K4,$A4:$Y4,1)+COUNTIF($A4:K4,K4)+1)

it works for some data but not all any issue with the formula

thanks

 

[etaf]

have a look here
Ranking Data In Lists

unique ranking
Acesnding
=COUNT($A$1:$A$5)-(RANK(A1,$A$1:$A$5)+COUNTIF($A$1:A1,A1)-1)+1

Descending
=RANK(A1,$A$1:$A$5,0)+COUNTIF($A$1:A1,A1)-1

 

[lokeshsu]

have a look here
Ranking Data In Lists

unique ranking
Acesnding
=COUNT($A$1:$A$5)-(RANK(A1,$A$1:$A$5)+COUNTIF($A$1:A1,A1)-1)+1
Descending
=RANK(A1,$A$1:$A$5,0)+COUNTIF($A$1:A1,A1)-1

Hi there Thanks for the reply but even this works for some data but not all it is showing duplicates in rank

 

[konew1]

Hi all,

i am using a rank formula to calculate the rank and i have multiple same values so i am using the below formula

=IF(COUNTIF([COLOR="#FF0000"]$A4:K4[/COLOR],K4)=1,RANK(K4,$A4:$Y4,1),RANK(K4,$A4:$Y4,1)+COUNTIF($A4:K4,K4)+1)

it works for some data but not all any issue with the formula

thanks

Don't you mean A4:Y4

 

[Aladin Akyurek]

Hi all,

i am using a rank formula to calculate the rank and i have multiple same values so i am using the below formula

=IF(COUNTIF($A4:K4,K4)=1,RANK(K4,$A4:$Y4,1),RANK(K4,$A4:$Y4,1)+COUNTIF($A4:K4,K4)+1)

it works for some data but not all any issue with the formula

thanks

Given:

3	6	4	4	6	7

<colgroup><col style="width: 48pt;" span="6" width="64"> <tbody>
</tbody>

What are the the expected results?