Hi!

That's how RANK works.

Try this:

=RANK($C49,$C$49:$C$62,1)+COUNTIF($C$49:$C49,$C49)-1

The first instance of a tie will be ranked higher:

25 = 4
10 = 1
10 = 2
22 = 3

Biff

"Todd Nelson" wrote in message
...
What is the formula to use that when ranking and two numbers are the same
it
will just assign it the next numerical value. I am
using"=RANK($C49,$C$49:$C$62,1)" some cells automatically will go to the
next
number, however most will not. I am throroughly confused!!!