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

i used

CellD1=

=SUMPRODUCT((B$2:B$10=B2)*(C$2:C$10C2))+1

but it returns the same rank for same values

do you know how to assign different rank for Sumproduct formula

thanks in advance


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

I found the answer of my question

you can paste
=SUMPRODUCT((B$2:B$10=B2)*(C$2:C$10C2))+SUMPRODUC T((B$2:$B2=B2)*(C$2:$C2=C2))

it is an array formula
control+shift+enter


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