View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
barkiny
 
Posts: n/a
Default ranking in a dynamic range help needed??


i have in column A there are companies
in column B there are values
in column C there are periods

i want to find the relative position of each company (RANK) referred to
each period

the problem is i dont know the range of the periods

can you add a dynamic range formula into ranking formula

thanks in advance


+-------------------------------------------------------------------+
|Filename: sheet2.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4761 |
+-------------------------------------------------------------------+

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=542083