how to get the consecutive rank when there are same ranks in column using rank function

[fashid]

Hi,

I have  a table which has a rank function in it .

two rows have the same rank 8.

After that there is rank 10 but i need that to be 9 and the last one to be 10.

Could it be possible.

Regards,

Nadeem

[sunny_talwar]

Then look at Michael's second solution.

[Anonymous]

That's exactly what my second version is doing

[fashid]

Hi Michael,

It was cool solution  thanks

I used

=RowNo(total)-rangesum(above(total if(num(rank(total Column(1),1))=above(num(rank(total Column(1),1))),1,0),0,RowNo(total)))

as the score was being calculated in the chart .

Difficult to understand the expression through .

Many thanks to everybody helping me in this solution.

Regards

Nadeem

[fashid]

Hi Michael,

I applied the logic in another chart but i am getting wrong ranks.

In the charts with the caption ENQ others and ENQ 4 SL i am getting wrong results.

In the charts with the caption conversion and CFR i am getting correct rank

I have used the same logic.but somehow unable to get the desired result

Could you please help me on this .

Regards,

Nadeem

[sunny_talwar]

Here is your potential issue (0s are not actual 0s)

[fashid]

Ok Many Thanks friend I used the round function to sort it.

[sunny_talwar]

Awesome