Did you confirm the formula with CONTROL+SHIFT+ENTER, not just ENTER?
Also, when I change the references according to your sample file to the
following...
=RANK(G2,G$2:G$15,1)+IF(COUNTIF(G$2:G$15,G2)1,MAT CH(MIN(B2:F2),SMALL(IF(
G$2:G$15=G2,SUBTOTAL(5,OFFSET(B$2:F$15,ROW(B$2:F$1 5)-ROW(B$2),0,1))),ROW(
INDIRECT("1:"&COUNTIF(G$2:G$15,G2)))),0)-1)
....and enter it in H2 and copy down, the formula returns the following
ranking...
2
1
3
6
4
8
7
9
11
5
14
10
12
13
Isn't this what you're looking for?
In article ,
chappo555
wrote:
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 |
+-------------------------------------------------------------------+