Thanks for the help. However none of these appear to work. I have added
a basic idea of what my data looks like and what results I get with the
XL RANK function.
The rank(countif(if etc function that domenic sent results in a #n/a
result.
The macro came up with a run error and Im obviously too stupid to
understand the r1c1 reply thingy.
sorry but I still need help. RANK only needs to be split when they
result in a tie in AGG column (col G). they are split by the MIN(b2:e2)
of each competitor. I was trying a RANK(IF(MIN style but without
success.
any help greatly appreciated.
4985
+-------------------------------------------------------------------+
|Filename: try rank forms.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=4985 |
+-------------------------------------------------------------------+
--
chappo555
------------------------------------------------------------------------
chappo555's Profile:
http://www.excelforum.com/member.php...o&userid=36060
View this thread:
http://www.excelforum.com/showthread...hreadid=558468