rank function error

Y

yshridhar

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

T. Valko

That's how RANK works. What result did you expect?
data rank
100 1
100 1
98 2
Click to expand...

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)
 
D

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
 
Y

yshridhar

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