Ranking Values that Meet a Certain Criteria
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
|