Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell rank= I need to reverse the order
Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse
the order to high # equal 1st not last |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell rank= I need to reverse the order
Change the 1 in your formula to a 0.
-- If this helps, please click the Yes button. Thanks! Allllen "Dennis Noble" wrote: Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse the order to high # equal 1st not last |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell rank= I need to reverse the order
Hello Dennis, As Excel help explains, the 3rd argument of RANK function determines the order. If it's zero or omitted then the ranking is in descending order. If it's any number other than zero then ranking is in ascending order, so to rank descending just remove the 3rd argument, i.e. =RANK(A1,A$1:A$9) copied down -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=106377 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell rank= I need to reverse the order
Hi,
You should simplify the formula to read: =RANK(A1,A$1:A$9) for descending =RANK(A1,A$1:A$9,1) for ascending using A1:A9 for the first argument instead of A1 gains nothing and is overkill. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Dennis Noble" wrote: Formula Rank=(A1:A9,A$1:A$9,1) this is working well but! I need to reverse the order to high # equal 1st not last |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reverse name order from Last, First to First Last in Exc | Excel Discussion (Misc queries) | |||
Order/Rank | Excel Worksheet Functions | |||
reverse order | Excel Discussion (Misc queries) | |||
How to reverse the order of data in a single column in Excell? | Excel Discussion (Misc queries) | |||
Tie breaking in a rank order | Excel Worksheet Functions |