View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] andy.hogan@gmail.com is offline
external usenet poster
 
Posts: 5
Default 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