Error with Rank Formula

[Asheesh]

Hi All,

I somehow don't see my head getting around this issue with rank function..

I am trying to rank some guys basis their performance..where in I dont need repetitive ranks..So, came up with a formula to do this but there seems to be something wrong...please see the attached...

Regards
Asheesh

 

[Sathish KV]

Hi,

Just hitting F2 and entered in the cells I12 and I15 solved the problem

 

[Asheesh]

@Sathish KV

Yes it does work if the values in "%age" column are keyed in manually or copy pasted...

But F2 doesnt work if these values are a result of a formula..please see the attached...

Regards
Asheesh

 

[Mike H..]

@Sathish KV

Yes it does work if the values in "%age" column are keyed in manually or copy pasted...

But F2 doesnt work if these values are a result of a formula..please see the attached...

Regards
Asheesh

Hi,

It's a precision error. Although the 2 values look the same they're not. If you click the button on the worksheet we do a vb compare of I12 and I15 and you will see it returns FALSE for I12=I15.

See the new columns I inserted which round the results to 4 decimal places and you formula works fine.

For an explanation of why look here.


https://support2.microsoft.com/kb/78113?wa=wsignin1.0

 

[Asheesh]

Hi Mike..thanks for your response...It was giving me hard time to understand the issue with rank..But ya agree using round would be the best way out here..

And yes the link is useful..

Regards
Asheesh

 

[Mike H..]

Hi Mike..thanks for your response...It was giving me hard time to understand the issue with rank..But ya agree using round would be the best way out here..

And yes the link is useful..

Regards
Asheesh

Hi,

You're welcome.