Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
I have a table which looks like this
PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
=RANK(A2,$A$2:$A$13)
works for me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
Cheers Bob,
But will this also automatically sort them into descending order? "Bob Phillips" wrote: =RANK(A2,$A$2:$A$13) works for me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
=SMALL($A$2:$A$13,ROW(A1))
will list the percentages in order. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... Cheers Bob, But will this also automatically sort them into descending order? "Bob Phillips" wrote: =RANK(A2,$A$2:$A$13) works for me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
Can't you just use Data--Sort to do this?
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Bob Phillips" wrote: =SMALL($A$2:$A$13,ROW(A1)) will list the percentages in order. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... Cheers Bob, But will this also automatically sort them into descending order? "Bob Phillips" wrote: =RANK(A2,$A$2:$A$13) works for me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
Hi Dave,
Yes I could but this table is being built from a seperate spreadsheet and I would like it to automatically arrange them in order as the information is entered into the other sheet. "Dave F" wrote: Can't you just use Data--Sort to do this? Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Bob Phillips" wrote: =SMALL($A$2:$A$13,ROW(A1)) will list the percentages in order. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... Cheers Bob, But will this also automatically sort them into descending order? "Bob Phillips" wrote: =RANK(A2,$A$2:$A$13) works for me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking
Cheers Bob that worked a treat.
"Bob Phillips" wrote: =SMALL($A$2:$A$13,ROW(A1)) will list the percentages in order. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... Cheers Bob, But will this also automatically sort them into descending order? "Bob Phillips" wrote: =RANK(A2,$A$2:$A$13) works for me. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Blade370" wrote in message ... I have a table which looks like this PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE 70.0% 5 3 1 1 10 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 50.0% 5 2 2 1 7 66.7% 3 2 1 0 6 75.0% 2 1 0 1 4 50.0% 2 1 1 0 3 12.5% 4 0 3 1 1 50.0% 1 0 0 1 1 25.0% 2 0 1 1 1 I want to rank by the percentage column but when it still seems to rank by games won. Any ideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking problem | Excel Worksheet Functions | |||
Ranking a List which must be within GROUPS | Excel Discussion (Misc queries) | |||
ranking with some blank spaces | Excel Worksheet Functions | |||
Numbers used for Ranking | Excel Worksheet Functions | |||
Ranking Using Grand Total | Excel Discussion (Misc queries) |