Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I would like to rank a group based on two Criteria, and i can't figure it
out. I've got a list of 10 teams and I want to rank them based first on winning % then by total points earned. Here is an exaple of the dataset: A B 1 .75 256 2 .48 305 3 .53 368 4 .53 412 So in this example, 1 would be first, then 4, then 3, then 2. I know that I can sort them and get the return manually, but I really don't want to have to manually sort the list every day. Any bright ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ranking Values that Meet a Certain Criteria | Excel Discussion (Misc queries) | |||
Any way to have a dynamic range for ranking, based on criteria? | Excel Worksheet Functions | |||
ranking based on criteria | Excel Worksheet Functions | |||
help using lookup and some kind of ranking criteria | Excel Worksheet Functions | |||
Ranking with criteria | Excel Discussion (Misc queries) |