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

"T. Valko" wrote:

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)


--
Biff
Microsoft Excel MVP


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