Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking
I need some assistance ranking a set of numbers. Here is the help screen
that Microsoft provides. A Data 1 7 2 3.5 3 3.5 4 1 5 2 Formula Description (Result) =RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3) =RANK(A2,A2:A6,1) Rank of 7 in the list above (5) This works great if I want to rank cell A1 #5. What is the formula is I want cell A1 (the highest) to be ranked #1? Thanks in advance for your help. Regards, Cory |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking
Never mind, I think I just figured it out. For those that are wondering, it
appears to me that the formula should be: =RANK(A2,A2:A6,0) Rank of 7 in the list above (1) This appears to work. If this is not correct, please let me know. Regards, Cory "dellbad" wrote: I need some assistance ranking a set of numbers. Here is the help screen that Microsoft provides. A Data 1 7 2 3.5 3 3.5 4 1 5 2 Formula Description (Result) =RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3) =RANK(A2,A2:A6,1) Rank of 7 in the list above (5) This works great if I want to rank cell A1 #5. What is the formula is I want cell A1 (the highest) to be ranked #1? Thanks in advance for your help. Regards, Cory |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking
Yes, that is correct, although you will probably want to make it:
=RANK(A2,A$2:A$6,0) if you want to copy it down. You could also look at the LARGE and SMALL functions. Hope this helps. Pete On Sep 10, 11:20 pm, dellbad wrote: Never mind, I think I just figured it out. For those that are wondering, it appears to me that the formula should be: =RANK(A2,A2:A6,0) Rank of 7 in the list above (1) This appears to work. If this is not correct, please let me know. Regards, Cory "dellbad" wrote: I need some assistance ranking a set of numbers. Here is the help screen that Microsoft provides. A Data 1 7 2 3.5 3 3.5 4 1 5 2 Formula Description (Result) =RANK(A3,A2:A6,1) Rank of 3.5 in the list above (3) =RANK(A2,A2:A6,1) Rank of 7 in the list above (5) This works great if I want to rank cell A1 #5. What is the formula is I want cell A1 (the highest) to be ranked #1? Thanks in advance for your help. Regards, Cory- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 10 Ranking again | Excel Discussion (Misc queries) | |||
Top 10 Ranking | Excel Discussion (Misc queries) | |||
ranking | Excel Worksheet Functions | |||
Ranking | Excel Worksheet Functions | |||
Ranking | Excel Discussion (Misc queries) |