Try this:

The higher goal differential is ranked better.

Entered in C1:

=RANK(A1,A$1:A$10)+SUMPRODUCT(--(A1=A$1:A$10),--(B1<B$1:B$10))

Copy down to C10

Biff

wrote in message
oups.com...
How can I rank a set of values in a range that meet a specified
criteria?

An example:
range A1:A10 contains the number of wins a team has. range B1:B10
contains each team's goal differential. For teams that have the same
number of wins, I want to be able to rank them on their goal
differential. I don't want to sort the list and then rank (this is a
simplified example) - rather having excel automatically identifying
all of the ties and breaking them.

Any help??

Thanks,
adh