LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crate group of date, with Dynamic Range in pivot table not working Tiya Excel Discussion (Misc queries) 3 March 1st 06 02:26 PM
help how to crate group of date with Dynamic Range? Tiya Excel Discussion (Misc queries) 0 February 27th 06 06:49 PM
dynamic summed range based on a variable Bruce Excel Worksheet Functions 3 November 8th 05 02:45 AM
Reference to a dynamic range Yossi Excel Discussion (Misc queries) 2 April 12th 05 12:57 PM
Add a Dynamic Range with 2 Conditions Q John Excel Worksheet Functions 7 December 23rd 04 02:58 PM


All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"