RANK.EQ rank same value different rank

[seang211]

Hi everybody,

I encountered some error with rank.eq as it rank the same number differently.
As per screenshot attached, I ranked "TOTAL" value.
Everything is fine until rank 16 and 17, the total value for both are 9.626 so they both should be ranked 16 but instead they are ranked 16 and 17.
Can you let me know what might be the issue here?

Thank you

 

[Domenic]

While the number being displayed in the cell contains 3 decimal places, it's likely that the underlying value is actually a number containing more than 3 decimal places. If the values in your column are a result of a formula, use the ROUND function to round the results to 3 digits.

Hope this helps!

 

[seang211]

Yup round does the magic thanks for your help Domenic.

 

[Domenic]

You're very welcome, I'm glad I could help.

Cheers!