rank function error

[Guest]

Rank() function is giving errors. eg
data rank
100 1
100 1
98 3
any suggestion please.
Thank you
Sridhar

 

[T. Valko]

That's how RANK works. What result did you expect?

data rank
100 1
100 1
98 2

If that's what you want try this:

=IF(A2="","",SUMPRODUCT(--(A2<A$2:A$4),1/COUNTIF(A$2:A$4,A$2:A$4&""))+1)

 

[David Hilberg]

That is deliberate behavior, not an error. It is as if two Olympic
athletes come in first with the same score, and the next runner up is
given a bronze medal, not silver.

- David

 

[Guest]

Thank you Mr. Bill. What I am expecting is
data rank expect
100 1 1
100 1 1
99 3 2
regards
Sridhar