|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 13th, 2009, 07:04 PM
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
June 13th, 2009, 07:38 PM
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
June 13th, 2009, 07:39 PM
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
June 13th, 2009, 08:36 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
