Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add numbers if they meet criteria...? | Excel Worksheet Functions | |||
how to sum highest ranking values meeting criteria within a limit? | Excel Discussion (Misc queries) | |||
Sum range of values that meet date criteria | Excel Discussion (Misc queries) | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
Sum the values of one column, only if they meet certain criteria . | Excel Worksheet Functions |