I was working on a solution along the lines of Domenic's solution when he
(Domenic) posted his response. It works fine with the data as you presented
it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chappo555" wrote
in message ...

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