Thread: Excell rank= I need to reverse the order
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barry houdini[_10_] barry houdini[_10_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote