# Posts by azumi

• ## Try to Rank in 2 Column Scores with Ties

Re: Try to Rank in 2 Column Scores with Ties

Yes, It does solve the problem, Thanks really appreciate for your time

• ## Try to Rank in 2 Column Scores with Ties

[TABLE="class: grid, width: 500, align: left"]

[tr]

[TD="align: center"]Score
[/TD]
[TD="align: center"]Rank
[/TD]
[TD="align: center"]Score
[/TD]
[TD="align: center"]Rank
[/TD]

[/tr]

[tr]

[TD="align: center"]25
[/TD]
[TD="align: center"]9
[/TD]
[TD="align: center"]26
[/TD]
[TD="align: center"]8
[/TD]

[/tr]

[tr]

[TD="align: center"]32
[/TD]
[TD="align: center"]6
[/TD]
[TD="align: center"]78
[/TD]
[TD="align: center"]3
[/TD]

[/tr]

[tr]

[TD="align: center"]78
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]200
[/TD]
[TD="align: center"]1
[/TD]

[/tr]

[tr]

[TD="align: center"]54
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]150
[/TD]
[TD="align: center"]2
[/TD]

[/tr]

[tr]

[TD="align: center"]15
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"]32
[/TD]
[TD="align: center"]6
[/TD]

[/tr]

[/TABLE]

I try to solve this problem with this formula :
B2
=RANK(A2;(\$A\$2:\$A\$6;\$C\$2:\$C\$6);0)

But it does'nt break the ties

Any add up for this formula?