Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excell rank= I need to reverse the order

11,612 views
Skip to first unread message

Noble@discussions.microsoft.com Dennis Noble

unread,
Jun 13, 2009, 2:04:01 PM6/13/09
to
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

barry houdini

unread,
Jun 13, 2009, 2:39:15 PM6/13/09
to

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/showthread.php?t=106377

Allllen

unread,
Jun 13, 2009, 2:38:01 PM6/13/09
to
Change the 1 in your formula to a 0.
--
If this helps, please click the Yes button. Thanks!

Allllen

Shane Devenshire

unread,
Jun 13, 2009, 3:36:01 PM6/13/09
to
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

0 new messages