Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse ranking
My first question, once I delete row 7 how do I get what was row 8 to turn
into row 7. Should I worry about it because it may throw off my forumulas? My second main question is how do I get a reverse ranking for lack of better term? For example, basketball scoring high is good "regular ranking." Golf on the other hand scoring high is bad. I am trying to rank the last column as if the rows were golfers and scoring high is bad and should have a high number not a low number. I am using the =RANK(N4,$N$4:$N$34) formula. This formula is for basketball and not golf. I have also tried =1+COUNT($N$4:$N$34)-RANK(N4,$N$4:$N$34) but the ranking went to 31 when I only have 27 values, it seemed to skip some numbers and I do not know how or why. I have tried small but it just says #N/A. The numbers I want to rank is N4:N34. Hope I have supplied enough info for someone to help me |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reverse ranking
once I delete row 7 how do I get what was row 8 to turn into row 7.
Excel automatically does that. If you delete row 7 Excel automatically shifts everything up from row 8 and below so that what once was row 8 is now the new row 7. For a rank where lowest is best: =RANK(N4,$N$4:$N$34,1) -- Biff Microsoft Excel MVP "JBG" wrote in message ... My first question, once I delete row 7 how do I get what was row 8 to turn into row 7. Should I worry about it because it may throw off my forumulas? My second main question is how do I get a reverse ranking for lack of better term? For example, basketball scoring high is good "regular ranking." Golf on the other hand scoring high is bad. I am trying to rank the last column as if the rows were golfers and scoring high is bad and should have a high number not a low number. I am using the =RANK(N4,$N$4:$N$34) formula. This formula is for basketball and not golf. I have also tried =1+COUNT($N$4:$N$34)-RANK(N4,$N$4:$N$34) but the ranking went to 31 when I only have 27 values, it seemed to skip some numbers and I do not know how or why. I have tried small but it just says #N/A. The numbers I want to rank is N4:N34. Hope I have supplied enough info for someone to help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 10 Ranking again | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions | |||
Ranking? | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) |