multiple criteria conditional ranking with ties

hi all,

having solved my initial problem ranking with multiple criteria,
now i am faced with another..what is in case of ties (eg below is part of my data)
i would want them be be ranked based on another range of values in column h,
making the tie at 4-4 becoming 4-5 and 15-15 to be 16-15.
the formula i used in column g is
=SUM(--(IF(E37="GAGAL",F37+1000,F37)>IF($E$37:$E$67="GAGAL",$F$37:$F$67+1000,$F$37:$F$67)))+1
also if the above formula is to be used in descending order, how should it be edited....thanking you in advance....

column e column f column g column h
LULUS 3.666666667 4 78.9
LULUS 3.666666667 4 76.8
LULUS 3.555555556 3 80.1
LULUS 5.555555556 17 66
GAGAL 9 29 30.3
LULUS 5.333333333 15 67
LULUS 5.333333333 15 69

hi wengqq3,
i should have uploaded a sample earlier for easier reference...
anyway, here is a sample...
in column g and h i ranked based on column e and f,
but i noticed quite a few ties in the results cos the data ranges are small,
therefore, i require the ranking formula in g and h to be altered to refer the ties to column i to break the ties...
urgently need the formula...thanks in advance...

Uploading a sample with Linked data in cells is not very helpful! Your sample should be a stand-alone sample.

hi
just edited the uploaded sample to a stand alone, kindly help....

Hi wenqq3

sorry for the vague sample, in fact those who have the same gpc in the same class or the whole form will be ranked tied (in the sample 17 triple tied, 8 triple tied and 4 double tied, the 17s should become 17, 18, 19 the 8s should be 8,9,10, and the like) which is what i am trying to break the ties by referring the ties to the column on average...

also while we are at this, how to use if formula with text, refer to sample file....